Data allocation from one level to other in different module

Hi,

 

I have 2 different list (L3 and L6)

I have 2 module, 1st module has L3 list is used and 2nd module with L6 list is used.

User able to enter data in 1st module (L3 list) and data should be copied into 2nd module at L3 member--- 1st ask

and data should be divided into L6 respective child members evenly.

 

Thanks,

Asha 

 

 

Best Answer

  • kavinkumar
    Answer ✓

    HI @AshaPatil,

    Follow the below steps to achieve this!! Note: Here I have taken an example between L3 and L5. Same is applicable in your case.

    Create 3 line items as per attached SS below in L5 module.

    Data allocation from one level to other in different module.PNG

     Create one line item in your L3 Module,

    Data allocation from one level to other in different module 1.PNG

    Hence your request is achieved. Please have a look at the below samples.

     Input Mod,

    Data allocation from one level to other in different module 2.PNG

     

    Since 1 has 6 child associated 600 has to be equally distributed among all the child as 100. Output,

    Data allocation from one level to other in different module 3.PNG

     

    I hope this helps you!! Let me know if you have any concerns.

    Regards,
    Kavin.

Answers

  • Hi Asha, Please follow these steps:

     

    1. In L6 module create 2 line items:

         a. Count - Number formatted with the formula as 1

         b. L3 Parent - L3 List formatted with the formula as PARENT(PARENT(PARENT(ITEM(L6 List))))

     

    2. In L3 module create 1 number formatted line item called Count with the formula L6 Module.Count

     

    3. Now in the L6 module create a line item with the formula: (L6 Module.Data[LOOKUP: L3 Parent] * Count)/Count[LOOKUP: L3 Parent]

     

    Please let me know if this helps

     

    Regards,

    Anirudh

     

  • Hi,

     

    Thanks for response. Solution works.

     

    Thanks & Regards,

    Asha

  • Hi,

    Why does it only works when Count - Number formatted with the formula as 1?

    Thank you