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 ?

 

prabhu

Hi @Shally, Use LOOKUP function.

 

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

 

 

 

 

 

 

 

Thanks,

 

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