Hello - I am trying to compare Q1'21 to Q2'21 in my report by showing a % increase in Total Revenue. I seem to be able to get the 5 working for all the static lines, but it is blank for the total line. Do you know what I may be doing wrong?
I used the formula in the column definition:
Thank you!
Steph
Hello Steph,
Can you take a look at this post and compare the way how you calculated your total with what is described in this article?
redbeardblogging.blogspot.com/.../how-to-do-cross-column-formulas-in.html
Best regards,
Ludwig
Hello -
It didn't seem to help. Now the Revenue total line is using the "row definition" formula to add up the lines above it, not perform the "column definition" formula to do a % increase/decrease from the previous quarter:
Any ideas, thanks again for your help!
Steph
Hello Steph,
Have you tried flipping the calculation priority as Osman suggested?
Did this fix your issue?
Best regards,
Ludwig
Hi,
try to change calculation priority on report definition.
Best regards.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (