I have two modules A & B where I want to use values of one line item of module A to be a part of a calculation in module B. Module A and B have no common dimensions in between them. Please help.
@AbhishekChatterjee14
Does Module A have anything to link to Module B, like an attribute of any kind?
Module A has these dimensions: a list for ^^Region at L3 level-(a hierarchical list), a list for products at L4 level-(a hierarchical list) and subset++ of another list for custom scenario versions. Module B has these dimensions: Region at L2 level-(flat list with some common names of regions in ^^), Growing method of products at L2 level-(a hierarchical list) & that same subset++ of another list for custom scenario versions.
Some pictures would help as I am having a hard time understanding what the lists are.
Module A dimensions → L3 Region (H), L4 Product (H), Custom Scenario list
Module B dimensions → L2 Region (F), L2 Product (H), Custom Scenario list
If these are the dimensions of the module then you need to either lookup/sum on Region list [I'm assuming L2 Product (H) is just parent of L4 Product (H)]
Now coming to formula → If you have mapping between L3 Region (H) to L2 Region (F) you can use sum with syntax of Sourcemodule.lineitem[Sum:L3 Region(H) - L2 Region (F) Mapping]
If you have mapping between L2 Region (H) to L2 Region (F) you can use lookup/sum with following syntax Sourcemodule.lineitem[lookup:L2 Region(H) - L2 Region (F) Mapping]
Hello folks, Does anyone know how to work around the Polaris limitation of using the Formula or Ratio summary method alongside the Closing Balance within the same line item? I have a Business Unit list where the total (All BUs) must display the Corporate (1 of 20 leaf items under All BUs total) number of Unique Customers.…
Has anyone found success using Anaplan XL with Polaris models in a shared drive with or without concurrent users? My team has experienced a variety of errors, login failures, etc. sometimes it works, sometimes it doesn't. We've been recommended to save and edit files locally, which helps but certainly with its limitations…
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.…
