Cube View Variance Calculation Issue
One row in my cube view is calculating a strange variance and variance %. I am subtracting an account member from a parent account in my Row member filter builder. Dep, & Amort is included in my SG...
Hi Denis, I think you are trying to achieve something like my example below:
Compared to your settings, I have changed two things - I have two columns, one with CY and one with PY and I use CVC for the variance calculations (you can do the same using only one column but you need to use indexes).
More important, I am using row overrides on the two calculated column (otherwise the row formula takes over)
Please let me know if that works for you as well.
