on 05-24-2011 2:01 PM
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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.