Skip to main content

Notifications

Finance | Project Operations, Human Resources, ...
Suggested answer

divide the values in a column by a single value in a row

(0) ShareShare
ReportReport
Posted on by 5

My question in the financial reporting module ,

how can I divide the values in a column by a single value in a row?

I tried using the following formula in "column Definitions" as an example "B/@100" 

but it didn't work. What is the solution?

  • Hana Xue Profile Picture
    Hana Xue Microsoft Employee on at
    RE: divide the values in a column by a single value in a row

    Hi Hatem,

    If your issue is resolved and this is useful information, can you please mark it as verified, thanks a lot!

    Best Regards,

    Hana

  • Suggested answer
    Hatem Ahmed Profile Picture
    Hatem Ahmed 5 on at
    RE: divide the values in a column by a single value in a row

    Hello Hana,

    Thank you so much. I have found the solution I was looking for from same link you sended. I truly appreciate your support.

    Best regards,
    Hatem

  • Suggested answer
    Hana Xue Profile Picture
    Hana Xue Microsoft Employee on at
    RE: divide the values in a column by a single value in a row

    Hi Hatem,

    It is mentioned in the documentation that you can use calculation formulas in row definitions, and you can refer to the examples in the documentation:

    pastedimage1684202883013v2.pngpastedimage1684202891516v3.png

    Advanced formatting options in financial reporting - Finance & Operations | Dynamics 365 | Microsoft Learn

    Best Regards,

    Hana

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Congratulations to the January Top 10 leaders!

Check out the January community rock stars...

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,160 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,962 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans