Can someone advise me how to compare two lists, one of it being number list ?
@algrigore
Great question. By "compare" I'm assuming you want to find where they intersect and where they don't. In Anaplan two lists can easily be compared, numbered or not, but there has to be a module that relates them together. Here is a quick way to accomplish what you want.
And if the numbered list doesn't have a code it's a bit tricker. You can look up in the non-numbered list but not the other way around.
In the FINDITEM formula will just need to reference the Display Name line item.
One way around no code in non-numbered is to have the module with both lists in it and have a line item that does numbered.display name = non-numbered.name(list) and then use that as a reference point with ANY as summary setting against the list modules.
Really make sure you've got codes in your lists!!
Hi,
I did the steps until the Boolean part, I`m not sure how to use the formula.
Do you have an example?
Thnaks
So where the numbered list is dimensioned you won't be able to have name(item(list)) as the reference point as that will just return a number. Do you have a display name that you'll be able to use instead.
Then in the check it's a simple isblank(WBS element) formula
Anaplan Modelers: Has Anyone Recreated a Showcase Model for Learning Purposes? One of the most valuable learning resources I've come across is Anaplan's Modeling Showcase. It features sophisticated, real-world model examples that offer an incredible opportunity to learn how experienced model builders structure their…
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…
