Formula to pull data from one member to another of the same list

Hi

What formula does one use to pull data from Member1 to Member2 of L1

L1

  |-- M1  - 10,000

  |-- M2 

 

or

from Actual to Budget ?

 

Answers

  • Hi @Shally, Use LOOKUP function.

     

    Create a System Module for mapping the list members in same list.

     

     

    Capture21.JPG

     

     

     

    Capture22.JPG

     

     

    Thanks,

     

  • @Shally  - For versions you can use PREVIOUSVERSION or NEXTVERSION function

     

     

     

  • hi @Shally 

    you can use lookup , create a table for mapping each element with value of list you need from and then use that mapping as lookup in target module

     

    here create a module with the l1 list and a line item with same l1 list as its format, then map m2 to m1