IF logic in Cube View GetDataCell

[Kit_Tyrrell]

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 looking at variance in an absorption account.  Any thoughts on how this could be done?  

[MikeG · Accepted solution]

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.

[Kit_Tyrrell]

Thank you very much for the suggestions.   The BWPercent worked for what I needed.

[MikeG]

Great!  Glad that worked for you @Kit_Tyrrell .