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

AnyaS
AnyaS
in Modeling

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

 

Tagged:

Answers

  • gaurav_sharma_17
    gaurav_sharma_17

    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

  • usman.zia
    usman.zia

    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

Categories