spread of value on identical children

MadhabikaM

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

Madhu

 

kavinkumar

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.

MadhabikaM

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

Madhu

kavinkumar

HI @MadhabikaM,

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-other-in-different-module/m-p/50023#M7155

I hope this helps!

Regards,

Kavin.

MadhabikaM

hi @kavinkumar ,

 

Thanks for your response.

 

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

Madhu