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 everyone 👋 If you build or maintain Anaplan models, you've probably hit the same walls I kept hitting. Some basic questions about a model's structure have no single screen to answer them. You end up clicking through modules and pages one by one, or writing API scripts just to get a list. These were the gaps that…
Hi Everyone, We have a requirement in Anaplan Consolidation & Reporting (Fluence) where the Entity Structure needs to change effective January 2026. The key requirement is that the existing entity structure should continue to be applicable for all reporting and consolidation periods through December 2025, while the new…
We've been building a tool called aplan4sheets and we'd genuinely like input from this community — both on what we've built so far and on what we should prioritize next. The problem we set out to solve: Anaplan's Excel add-in is Windows-centric, and there's no real native way to pivot Anaplan data in Google Sheets. We…
