Skip to Content
0
Former Member
Nov 02, 2005 at 08:25 PM

Hierarchy and summing up issue

49 Views

Hi,

I have a hierarchy structure and nodes under it and am reporting a particular Restricted key figure. The figure has both positive and negative values, I need to report the absolute value summed up the higher node, but any calculation i make is w.r.t the already summed up values.

Example:

THis is how it is reporting now:

Char____________ RKF ____ CKF(=|RKF|*2)

-


H-1 ____________ 40 _____ 80

H-2___________ 40 _____ 80

____N1__________ 100 _____ 200

____N2__________ 150 _____ 300

____N3__________ -200 _____ -400

____N4__________ -10 _____ -20

This is how I want:

Char____________ RKF ____ CKF(=|RKF|*2)

-


H-1 ____________ 40 _____ 920

H-2___________ 40 _____ 920

____N1__________ 100 _____ 200

____N2__________ 150 _____ 300

____N3__________ -200 _____ 400

____N4__________ -10 _____ 20

Any suggestions would be greatly appriciated

Gokul