Announcements
No record found.
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
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
Yes Ludwig
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.
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,
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.
Congratulations to our 2026 Super Stars!
Thanks to all of our 2025 Community Spotlight stars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Joris dG 5
Sagar Suman 2 Super User 2026 Season 1
Alexey Lekanov 2
