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

Question

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 ?

Kanishq17 · Answer

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

prabhu · Answer

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

prabhu · Answer

Hi @Shally, Use LOOKUP function.

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

Thanks,