Calculation logic for different hierarchies
Hi
In source module I am having Hierarchy list with 6 levels(L1,L2,L3,L4,L5,A) where A is lower level of hierarchy which is having some count line item.
In target module I am having L5 as dimension with litem as Total Count.
Scenario 1: Now we are moving A1, A2 from it's L51 to L52, where L41 is parent of L51 and L42 is parent of L52(moving out of hierarchy of L4). As parents of L51 and L52 are different then it should refer count from source module to L41 level in target module in Total Count line item.
Scenario 2: Now we are moving A1, A2 from it's L51 to L52, where L41 is parent of L51 and L42 is parent of L52. Also L31 is parent of L41 and L32 is parent of L42(moving out of hierarchy of L3 and L4). As L3's and L4's both are different then it should refer count from source module to L31 level and L41 level in target module in Total Count line item.
Scenario 3: Now we are moving A1, A2 from it's L51 to L52, where L41 is parent of L51 and L42 is parent of L52. L3's are same for both L41 and L42(moving out of hierarchy of L4 and not for L3). As L4's are different and L3's are same then it should refer count from source module to L41 level in target module in Total Count line item and it should be zero for L31.
Similarly it should follow the combinations for all levels(L5,L4,L3,L2,L1).
Source Module:
Count  
L31  
L41  
L51  
A1  80  
A2  100  
L32  
L42  
L52  
A3  200  
A4  150 
Target Module:
Total Count(Line Item)  
Scenario 1  Scenario 2  Scenario 3  
L51  180  180  180 
L51.1  0  0  0 
L41  180  180  180 
L31  180  0  
L21  
L11  
L52  
L42  
L32  
L22  
L12 
Could anyone please help me on this.
Thanks
Shirisha.
Comments

Could you explain further, perhaps with some screenshots.
What do you mean when you say "moving"? What are Scenarios here, a list or Versions? What is the formula for Target Module.Total Count?
Let's see blueprint screenshots for the source and target modules...0