Active Child list members under a parent

GuruAP
GuruAP
in Modeling

Hi - Say I have a hierarchy with two levels: L1 and L2, L1 being the parent. Not all L2 members are at a point of time active under L1. So, we have a module that specifies which L2 member is active in a month (identified by a boolean).

For disaggregating the data from L2 to L1, I need to ensure the volume is disaggregated only on to the active L2 members (the proportion for each L2 member is an input). If I have only one active L2 member under an L1 member, the volume of L1 member is 100% allocated to the L2 member. If the number of ACTIVE L2 members is > 1, then the volume at L1 member is disaggregated by %age input for each L2 member.

I am having the challenge of how to identify the number of active L2 members. Can someone please help?

Thanks,

Regards - Guru

Tagged:

Best Answer

  • prabhu
    prabhu
    Answer ✓

    Hi @GuruAP 

    • Create a Line item (Count - Number Format) - Set it as 1 when the child is active else 0

     

     

    • Capture.JPG
    •  
    • Capture1.JPG

     

     

    Here i didn't create any system module, i gave you an idea of how to get the child count.

     

    Let me know if you need more clarity

     

     

Categories