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 ?

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

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

|-- M1 - 10,000

|-- M2

from Actual to Budget ?

Hi @Shally, Use LOOKUP function.

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

Thanks,

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

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

New UX Filtering for Hierarchy sibling
I have A6 as the parent list and two sibling lists: A6.5 and A7. The A7 list includes an attribute that maps to A6.5. In the UX, the user will select A6.5 using a content selector, and the grid (dimensioned by A7) should display only the A7 items associated with that selected A6.5. Since the selector is a page context and…
A reminder of Bulk Copy - Current year to Prior year version for YoY analysis
A quick reminder of the Bulk Copy functionality. Bulk Copy allows you copy large volumes of data from one slice of a model to another in a single, optimised operation, instead of using formulas or imports. Use case: copy a version (RF1) into a prior year version (PY RF1) using a versions list to allow for year-on-year…
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…