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

 

Best Answers

  • kavinkumar
    Answer ✓

    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
    Answer ✓

    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

Answers