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?
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.
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.
Hi @Himaniam
Please answer the following questions. I'll try to help you.
Thanks!
-Shubham
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.
Thanks & Regards
Meda Ganesha Manikanta
Matasma Digital Technologies
In the Sales Planning model, create two lists to import data from the Data Hub model. The first list should include the data that will identify the relationship between Sales Reps and the country where they are located. Q: Employees list keeps showing as a unique id instead of the employee name when importing from data hub…
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.…
Estimated Level of Effort:4-8 Hours of Model Building Level of Difficulty: Beginner Recommended Training: L2 Model Builder Training Persona: Casual Model Builder Potential ROI: Decreased planning time Increased accuracy of targets/spreads You Might Also Like: * Historical Snapshotting Top-Down Allocations Whether it's…
