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

Best Answer

  • LipChean_Soh
    Answer ✓

    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

Answers

  • Hi @da ,

     

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

     

    Regards,

    vinayvm