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
Dear Hive Mind, Do we have a way to get the history of a particular List Item, from its creation into a model up until its removal ? I am trying to chase when / how an item has been added into a model and how / when it would have been deleted and then recreated with the same code. Is there a pattern (manual or API) to getβ¦
I have an action in a process which is getting failed since 2 days when run via CloudWorks with below error . No issues when run manually . Same error occurs when run manually but as a warning "Import complete but with failures" This action is running since almost a year without any issue . No change has been made toβ¦
Hi, I have a module with a time range as a dimension. I've set it with a daily time scale, but Anaplan's way of showing daily dates is for example "1 Jan 37" and I need it to be in numbers because when I export it excel doesn't recognize it as the date format that I've set in Windows (OS) (when a date as two digits it'sβ¦
