Conditional formatting on variance versions
Hi, I would like to apply conditional formatting on a dashboard. I have a module based on 3 versions.
-Annual Plan (AP)
Variance = Actual - AP
Now the conditional formatting should be green if the Variance >0 and red when <0. However when I apply conditional formatting all versions will be formatted.
I have tried the following to add an extra line item for the sake of the conditional formatting only, which results in a 0 value for the actual and AP version and with (potentially) a negative or positive number for the Variance version. However this would not help as the Variance version is overridden with the version formula (Actual- AP).
Any tips or trics will be appriciated.