## spread of value on identical children

Highlighted
Frequent Contributor

## spread of value on identical children

Hi,

I have two modules, using two different list List1 and List2.

List 1 module has a member FM and a line item amount value as 100.

List 2 module has members FM1, FM2, FM3 & FM4.

I want to spread FM value 100 from module 1 in module 2 having total four member starting with FM

as 100(value)/4(count of FMnodes) = 25 each.

Regards

4 REPLIES 4
Highlighted
Master Anaplanner/Community Boss

## Re: spread of value on identical children

What is the relation between List 1 and List 2. Is it a Parent & Child relationship? If yes then you can follow the below thread,where I suggested a solution.

https://community.anaplan.com/t5/Anaplan-Platform-Discussions/Data-allocation-from-one-level-to-othe...

I hope this helps!

Regards,

Kavin.

Regards,
Kavin.
Highlighted
Frequent Contributor

## Re: spread of value on identical children

hi @kavinkumar ,

To answer you below, there is no relationship between two list.

Only relationship is the name(text) - FM.

can I derive FM in a line item for List 1 and lookup with all nodes starting FM in List 2, get the count of FM nodes and spread in them.

Regards

Highlighted
Master Anaplanner/Community Boss

## Re: spread of value on identical children

Oh, then try this,

Step 1: Create 3 line items in module 2 and refer the formula below.

Step 2: Create 1 line item in Module 1,

End result,

I hope this helps!!

Regards,

Kavin.

Regards,
Kavin.
Highlighted
Frequent Contributor

## Re: spread of value on identical children

hi @kavinkumar ,

Thanks this works fine.

I had tried for this option but the issue here was, both the module had different time range and time scale setup.

so, also this needs to be in sync to apply the below logic.

Regards