Contributor

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 

 

 

3 REPLIES 3
Highlighted
Certified Master Anaplanner

Re: Data allocation from one level to other in different module

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

 

Certified Master Anaplanner

Re: Data allocation from one level to other in different module

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.

Contributor

Re: Data allocation from one level to other in different module

Hi,

 

Thanks for response. Solution works.

 

Thanks & Regards,

Asha