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 ?
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
hi @Shally
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
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…
