Comparing values against the same dimension

Use case:

Prod A was sold for 100$ as part of Plan A, 120$ as part of Plan B and 150$ as part of Plan C, I need to determine the increase/decrease in price for each plan. How can this be achieved in Anaplan?

Accepted answers

All comments

ShawnAwan

Can you give more context? What output value are you seeking (Boolean, percentage, IF/THEN/ELSE, comparative)? Also, what are you comparing against? Are you wanting a SYS module or to use a formula to have it on the same module as a line item?

Normally, in FP&A, when we do increase/decrease, we measure against a reference or original data on a sheet as a percentage but once we have clarity, we can figure out how to resolve this.

Himaniam

The output is row marked as "Increase in Price", basically a number value which gives the difference in price between Plan A and Plan B, similarly difference in price between Plan B and Plan C. I am comparing the prices against different plans. Ideally a formula to have it in the same module as a line item but if that is not possible then a sys module should work.

ShubhamCh

Hi @Himaniam

Please answer the following questions. I'll try to help you.

Are there two dimensions or only one?
Do you want to see the differences for only one product or do you have many products?
Are there only three Plans or more?

Thanks!

-Shubham

medaganeshamanikanta

Hi @Himaniam

I figured out a solution to your question.

Here I am attaching Grid View and Blueprint View of the build that I made.

I have developed the concept similar to offset anaplan functionality.

Screenshot 2023-02-17 182449 gv up.jpg

Screenshot 2023-02-17 182419 bp up.jpg

Thanks & Regards

Meda Ganesha Manikanta

Matasma Digital Technologies

Quick Links

Can you help?

Unanswered questions

New UX Filtering for Hierarchy sibling
I have A6 as the parent list and two sibling lists: A6.5 and A7. The A7 list includes an attribute that maps to A6.5. In the UX, the user will select A6.5 using a content selector, and the grid (dimensioned by A7) should display only the A7 items associated with that selected A6.5. Since the selector is a page context and…
A reminder of Bulk Copy - Current year to Prior year version for YoY analysis
A quick reminder of the Bulk Copy functionality. Bulk Copy allows you copy large volumes of data from one slice of a model to another in a single, optimised operation, instead of using formulas or imports. Use case: copy a version (RF1) into a prior year version (PY RF1) using a versions list to allow for year-on-year…
Looking for Anaplan End-Users to take a short survey!
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.…