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

Shally · 2020-06-03T08:36:38+00:00

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 ?

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

|-- M1 - 10,000

|-- M2

from Actual to Budget ?

Accepted answers

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

Has anyone taken a stab at Master Anaplanner Recertification exam yet?
Just curious :)…
Solution for indent diabled for hierarchical list when the page has more than two axis
Hello fellow Anaplaners, I have a question about the UX for Anaplan for hierarchical list. If I have a list with multiple layers, say P1, P2, P3, and P4, and the workpage had 2 axis, list and line items, in its vertical axis and time in its horizontal axis (see figure below) The list is shown without indentations, and may…
Best way to Architect Financial Statements in Anaplan for Scalability
I have seen two methods used to build financial statements and I am wondering what others have experienced in scalability/maintenance between the two or if there is a better approach. Assume that we have a flat data source for our general ledger within Anaplan. Our line item we are focused on within the source data is the…