Forum Discussion

bisenhart's avatar
bisenhart
New Contributor II
2 years ago

How to add a formula in a cubeview

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?

Cube View
  • MarkBird's avatar
    MarkBird
    2 years ago

    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

     

  • MarkBird's avatar
    MarkBird
    Contributor III
    2 years ago

    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