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

Madhu

 

4 REPLIES 4
Certified Master Anaplanner

Re: spread of value on identical children

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-othe...

I hope this helps!

Regards,

Kavin.

Highlighted
Contributor

Re: spread of value on identical children

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

Certified Master Anaplanner

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.

spread of value on identical children.PNG

 Step 2: Create 1 line item in Module 1,

spread of value on identical children 1.PNG

End result,

spread of value on identical children 2.PNG

 

I hope this helps!!

Regards,

Kavin.

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

Madhu