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