Data allocation from one level to other in different module
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.
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.
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.
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
Thanks for response. Solution works.
Thanks & Regards,
Why does it only works when Count - Number formatted with the formula as 1?