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

Accepted answers

kavinkumar

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.

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

All comments

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

kavinkumar

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.

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

Quick Links

Can you help?

Unanswered questions

Batch Script
Hello team, I am logging into Anaplan through SSO. I would like to create a batch script to import a file into Anaplan. For the Spoke model, I would like to run an process via a batch script to import data from the Data Hub. Can anyone provide me script for both the condition.
import monthly data with months in columns
is there a way to import data with months in columns (usual excel table view)? I have to transform the data so there are rows to cover each period in the upload data form, but I am wondering if there is a better way to just import the data as is with the months in the columns. please let me know what you think. thank you,
Cloudworks Big Query Integration Fail
Hello, I am receiving an 'Anaplan Upload Failed' Status Description when testing my integration with a Big Query dataset. The integration imports data from BQ to our Anaplan model. No other details given in the error log. I suspect that Cloudworks is not even picking up the file but am not sure what we did wrong on the set…