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

 

Answers

  • 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