You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Variance logic on calculated rows

edited Sep 17, 2026 2:32PM in Narrative Reporting 3 comments

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:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!