If anyone has an interest, I have a recipe that allows to replicate Excel What-If Two-Variable Data Table functionality in Anaplan aka sensitivity/incremental change analysis of drivers.
Hey Anya,
I would like to know the methodology you have used to do the What-if Analysis. I had a similar situation in my project which I achieved via Import actions. First, I would import the input value and then snapshot the output to a output module. I would not consider my approach as the most efficient method of performing What-if Analysis as actions are slow and might also lead to funny results in some cases. Looking forward to hearing from your side on how you created the What if analysis in Anaplan.
Cheers,
Gaurav
Hey @AnyaS thanks for sharing!
Would it be possible to share the blue print view and formulas? this would help us to see more in detail how the method works.
I agree with @gaurav_sharma-bng using import processes can make it easier when dealing multiple changing variables like this.
Thanks,
Usman
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…
Estimated Level of Effort: <4 Hours of Model Building Level of Difficulty: Beginner Recommended Training: L1 Model Builder Training Persona: Casual Model Builder Potential ROI: Decreased response time to address risks Increased forecast accuracy You Might Also Like: * Tops-Down Allocations Historical Snapshotting One of…
