How to add a formula in a cubeview

[bisenhart]

I'm looking to add a formula that takes an account and subtracts the difference between two scenarios. So, something like this: GetDataCell(A#ProductionTCFacSTd:S#Target_FY24) - GetDataCell(A#ProductionTCFacSTd:S#Target_FY24_SC). Can you please help see what I need to do to make this work in my cube view?

[MarkBird · Accepted solution]

Hi @bisenhart, we need a bit more information to help you.

But it should be very simple, first, put the account filter in your row definition E.g.:

Then in your row definition you can put the variance formula:

You have a few different options that you could use:

1. GetDataCell(Variance(S#Target_FY24_SC,S#Scenario2)):Name(Variance)

2. GetDataCell(S#Target_FY24-S#Target_FY24_SC):Name(Difference)

3. GetDataCell(BWDiff(S#Target_FY24,S#Target_FY24_SC)):Name(Better or Worse Diff)

Regards,

Mark