Hello,
I have a report and like to calculate differences as follow,
CurrMon PrMon Diff
AAA
A111 40 10 40
A112 20 5 15
BBB
B111 30 50 20
B112 60 70 10
As you can see from above example that for AAA I wanted to calculate
Diff = CurrMon - PrMon
From BBB and onwards
Diff = PrMon - CurrMon
So how do I setup two different formulas and display the value for only that section?
Any help appreciated.
Thanks..