Data allocation from one level to other in different module

AshaPatil

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 

 

 

kavinkumar

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.

 Create one line item in your L3 Module,

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

 Input Mod,

 

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

 

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

Regards,
Kavin.

anirudh

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

 

AshaPatil

Hi,

 

Thanks for response. Solution works.

 

Thanks & Regards,

Asha

Brfonseca

Hi,

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

Thank you