Hello,
I have the follow data and am looking for the % change between 2024 Forecast and 2023 Actual:
The YOY % change is coming from my custom SQL and therefore is adding together all the rows that add up in the currency and RAG rating level (no good).
I then made the % change column. This is accurate for all the rows except the grand total. Where the grand total is showing as a SUM of the % change, not the % change of the grand total.
Using LOD calculations I have created % Change LOD which is calculating the % difference for the grand total line correctly (3%).
My question is, how do I merge these partly accurate calculations to give me everything I want in one column? I have tried an IF statement but was met with the "you can't use aggregates for this formula" malarkey.
Is there perhaps an easier way to calculate what I want?
