Variance logic on calculated rows
Summary:
Is it possible to determine the right sign on a calculated row to get the right variance amount?
I know, ideally those calculated members would be added as an alternate hierachy in my account dimension, so the parent also gets the right variance reporting setting, but … adding this in the dimension is not an option for the client.
Ideally we can make it work at the report level.
Content (please ensure you mask any confidential information):
How can I achieve the top, summed row to show 102 instead of -102?
Unfortunatly the sum line is using the real numbers from row 4. The variance just seems like an additional formatting layer above the numbers.
Tagged:
0