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

[Shally]

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 ?

[Sorna Raja Prabhu]

Hi @Shally, Use LOOKUP function.

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

Thanks,

[Sorna Raja Prabhu]

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

[Kanishq17]

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