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

1 ACCEPTED SOLUTION

Accepted Solutions
Certified Master Anaplanner

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.

Regards,
Kavin.
3 REPLIES 3
Community Boss

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

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.

Regards,
Kavin.
Contributor

Hi,

Thanks for response. Solution works.

Thanks & Regards,

Asha