You’re offline. This is a read only version of the page.
Announcements
Hello!
I'm trying to create a Gross Margin % calculation in my IS report row. There are a total of 6 reporting trees needed on this report.
I have the equation set and calculating fine with "@Gross Margin/@Total Revenue", but when the report generates, it calculates the Gross Margin of EACH TREE, and then adds them all together for the report.
So, instead of getting roughly 84% Gross Margin, I'm getting 400%.
I'm fully aware that I could just have a separate column dedicated to %'s, but I was trying to remove that column and just have this GM% calc, if it is feasible.
Thank you for any help.
*This post is locked for comments
#1
André Arnaud de Cal...
291,359
Super User 2024 Season 2
#2
Martin Dráb
230,370
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (