cancel
Showing results for 
Search instead for 
Did you mean: 

Hierarchal Calculation

Former Member
0 Kudos

Dear All,

I Have one requirement in Hierarchies:-

Info object Sales region node having amount = 50 under that sub bode sales office 1 = 10,sub node sales office 2 = 20.

Now in new coloum 50-10 = 40

50-20 = 30

Is it possible .....to do calculation on hierarchies

Regards,

Varun

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

hi,

This may be possible by displaying the data for the hierarchy.

There are Data functions in formula, you can use SUMCT which will pick data of Result of Hierarchy.

create a CKF define it as SUMCT - value.

Hierarchy CKF

top node 50 50-50

node 1 10 50-10

node 2 20 50-20

Result 50

you can choose your aggregation type for the result of this CKF.

regards,

Arvind.