Anaplan Substitute for Excel What-If Two-Variable Data Table

Highlighted
Occasional Contributor

Anaplan Substitute for Excel What-If Two-Variable Data Table

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.

 

ANAPLAN SUB FOR EXCEL DATA TABLE.png

 

2 REPLIES 2
Highlighted
Certified Master Anaplanner

Re: Anaplan Substitute for Excel What-If Two-Variable Data Table

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

Highlighted
Master Anaplanner/Community Boss

Re: Anaplan Substitute for Excel What-If Two-Variable Data Table

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