Skip to Content
0
Jun 08, 2018 at 12:46 PM

Formula Question

58 Views

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..