Dimensionality - Formula Help

SAITTAS · 2025-06-12T17:10:23+00:00

There was an error rendering this rich post.

I have a Price module where customers are ranked based on their unit prices.
I also have a Comparison module, where I want to display the names and unit prices of top-ranked customers for comparison.
The model includes a Customers list.

In the Comparison module, I want to write formulas to bring in the customer names and unit prices for:

Tier 1 customer (rank 1)
Tier 2 customer (rank 2)
Tier 3 customer (rank 3)

What’s the best way to write these formulas?

Grid views of modules:

Blueprint views of modules:

Thank you.

Accepted answers

Amaya

Hi @SAITTAS

After considering your question, I think using a list for tiers 1-3 would work better than line items.

I've created a list-based version of the module below to fetch the top 3 prices.

{0147126D-289D-4BAF-845D-329A99EFC439}.png

Please note that FINDITEM should generally be avoided as a best practice, but I couldn't find an alternative approach for this specific case.

Hope this helps!

Taichi

All comments

Amaya

Hi @SAITTAS

After considering your question, I think using a list for tiers 1-3 would work better than line items.

I've created a list-based version of the module below to fetch the top 3 prices.

Please note that FINDITEM should generally be avoided as a best practice, but I couldn't find an alternative approach for this specific case.

Hope this helps!

Taichi

SAITTAS

Hi @Taichi,
Thank you for your response.

I built the solution you suggested using the Comparison with Tiers List module. I used the Tiers Lookup module to pull the numbers into the Comparison module.

Here are the grid and blueprint views of the modules in case anyone wants to recreate it.

Quick Links

Can you help?

Unanswered questions

Has anyone taken a stab at Master Anaplanner Recertification exam yet?
Just curious :)…
Solution for indent diabled for hierarchical list when the page has more than two axis
Hello fellow Anaplaners, I have a question about the UX for Anaplan for hierarchical list. If I have a list with multiple layers, say P1, P2, P3, and P4, and the workpage had 2 axis, list and line items, in its vertical axis and time in its horizontal axis (see figure below) The list is shown without indentations, and may…
Best way to Architect Financial Statements in Anaplan for Scalability
I have seen two methods used to build financial statements and I am wondering what others have experienced in scalability/maintenance between the two or if there is a better approach. Assume that we have a flat data source for our general ledger within Anaplan. Our line item we are focused on within the source data is the…