12-14-2023 09:53 AM
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?
Solved! Go to Solution.
12-14-2023 10:55 AM
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:
GetDataCell(Variance(S#Target_FY24_SC,S#Scenario2)):Name(Variance)
GetDataCell(S#Target_FY24-S#Target_FY24_SC):Name(Difference)
Regards,
Mark
12-14-2023 10:55 AM
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:
GetDataCell(Variance(S#Target_FY24_SC,S#Scenario2)):Name(Variance)
GetDataCell(S#Target_FY24-S#Target_FY24_SC):Name(Difference)
Regards,
Mark