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

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.…
CERTIFICATION BADGES - ANNOUNCEMENT
Anaplan Champions! The Community team just posted this announcement that certification badges may not be showing up on your profile probably until next year. Rest assured, you will get credit once you complete and pass the exams. https://community.anaplan.com/t5/Blog/Badges-Back-Soon/ba-p/123385