Forum Discussion

Kit_Tyrrell's avatar
Kit_Tyrrell
New Contributor II
2 years ago

IF logic in Cube View GetDataCell

Hello, I am trying to find a way to have my variance % follow my dollar variance value.   If a favorable variance, then the % variance should also be a positive percentage.  In this example I'm look...
  • MikeG's avatar
    2 years ago

    Hi Kit_Tyrrell , have you tried using VariancePercent function in your column definition?  You can reference the other columns using CVC references.

     

    In your use case, BWPercent may work better, that one takes in to consideration the Account Types  Here's an example of that one from the Help doc.

    hope this helps.