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

Issue with Anaplan tab in Salesforce
I have installed the Anaplan app in Salesforce, but have been receiving an error. In the Anaplan part it asks for you to contact support, but does not provide any details into how to do this, just raising a ticket in the portal? WOuld be great to have more information.…
Data Integration to Fluence workspace
Hello Everyone, I am seeking guidance on how I could create a workflow process in Fluence consolidation workspace, using the ADO import task. Does anybody know what kind of information I need to fill in these fields? I have watched the ADO training but only explains the data transformation and integration within Anaplan…
Pagination in Management Reports Without splitting Parent Blocks
Hi I would like to set up pagination in management reports by assigning a page number to a list item and its parent but I also want to be able to keep a block of parent and list items together and not split over two pages. E.g. Parent 1 - 1 Child 1 - 2 Child 2 - 3 Parent 2 - 4 Child 3 - 5 Child 4 - 6 Child 5 - 7…