web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Microsoft Dynamics AX (Archived)

Management Reporter - Formulas In Row Definition

(0) ShareShare
ReportReport
Posted on by 660

Dear All,

I want to add a formula in the row definition which divides the total gross margin by the base period that I select while generating the report.

How can I do the same?

*This post is locked for comments

I have the same question (0)
  • Ludwig Reinhard Profile Picture
    Microsoft Employee on at

    Hello Binit,

    If I get you right then you want to divide the gross margin let's say in May by 5, in June by 6, in July by 7 and so on. Is that right?

    Ludwig

  • binitshah Profile Picture
    660 on at

    Yes Ludwig

  • Suggested answer
    binitshah Profile Picture
    660 on at

    Hi Ludwig,

    For the time being since I could not find such formula I used an alternative where first I created an excel with different numbers and created a report which is linked to this excel.

    Then I linked my original report to this report which helps to get the exact number and hence I can divide by the number.

  • Ludwig Reinhard Profile Picture
    Microsoft Employee on at

    Hi Binit,

    I think your 'workaround' is the easiest option. Other than the Excel integration I could imagine that this could be realized by using conditional column printing options and non-printing columns and rows. Yet, I have never tested such kind of setup and would imagine that it will result in a complex report setup (if it is possible at all?!)  

    Do you mind verifying your last response as verified answer?

    That is because I believe that a lot of other AX users have similar requirements and might want to use the approach you found.

    Many thanks and best regards,

    Ludwig

  • binitshah Profile Picture
    660 on at

    Dear Ludwig,

    The workaround did work and I got the expected results.

    Thank you for your prompt reply.

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Joris dG Profile Picture

Joris dG 5

#2
Sagar Suman Profile Picture

Sagar Suman 2 Super User 2026 Season 1

#2
Alexey Lekanov Profile Picture

Alexey Lekanov 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans