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]
Hi, I wonder if there's a way I can sort my general list alphabetically. The list is used as a drop down menu in a line item module and I want the drop down menu to be easy to navigate. I've already tried the Order List action. I already have a module with a text-formatted line item based on that list. But when I try to…
Hello Anaplan Community, I have a special requirement from a customer and would appreciate your input. Let me explain the situation: We have a hierarchy with three levels: Level 1, Level 2, and Level 3. Screen 1: Creation of Level 1 Items On this screen, the user selects a team. Based on their selection, an action runs to…
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.…
