Parent Child addition

da
Occasional Contributor
Occasional Contributor

Parent Child addition

Hi ,

I need a help in calculation of data at lowest hierarchy level giving values to parent level.

For example,

l0l1L2DataExpectedFunction used
Aa1b11133

=SUMIF

 

Aa1b12233 
Aa2b2111443 
Aa2b2222443 
Aa2b2110443 

 

Here, I want values added of all the l2 who has same parent. Can anyone suggest me way out?

 

Thanks,

Divya

1 ACCEPTED SOLUTION

Accepted Solutions
LipChean_Soh
Certified Master Anaplanner

Re: Parent Child addition

Hi @da 

 

Below is an example of how you can do it. Please create a System module, i.e. L2 Details to follow the DISCO methodology.

LipChean_Soh_0-1621991399631.png  LipChean_Soh_1-1621991413742.png

 

LipChean_Soh_2-1621991444235.png

 

Thanks,

LipChean

View solution in original post

2 REPLIES 2
vinayvm
Certified Master Anaplanner

Re: Parent Child addition

Hi @da ,

 

You can create a Parent property in the L2 List (lowest level), and then use this property to lookup.

 

Regards,

vinayvm

LipChean_Soh
Certified Master Anaplanner

Re: Parent Child addition

Hi @da 

 

Below is an example of how you can do it. Please create a System module, i.e. L2 Details to follow the DISCO methodology.

LipChean_Soh_0-1621991399631.png  LipChean_Soh_1-1621991413742.png

 

LipChean_Soh_2-1621991444235.png

 

Thanks,

LipChean

View solution in original post