Skip to Content
avatar image
Former Member

Subtraction in hierarchy

Hello I need some help with hierarchy help.. The users want to subtract a roll up from a hierarchy, but changing to calculate total as sum breaks when they expand hierarchy.

So they want it like this They want the parent to be child 1 minus child 2. They also don't want to have to display the hierarchy for the subtraction to work.

Parent

CHild 1

Child 2

Child of Child 2

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Mar 20, 2017 at 12:42 PM

    Hi Matt,

    you can use the hierarchy attributes for sign reversal and a formula in the query where you multiply the key figure value with the hierarchy attribute value (+1 or -1). You get this value using a formula variable of the corresponding type, cf. documentation.

    Regards,

    Gregor

    Add comment
    10|10000 characters needed characters exceeded