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.
Go to Solution.
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.
I hope this helps!
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.
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,
I hope this helps!!
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.