What-if Analysis in Excel to Anaplan.
@bbolton , Our optimizer can give us only the optimum result, but not all possible results which the Excel "What if" does. Essentially "What if" is a loop of different values for some variables and a resultant is calculated. We can do this in Anaplan, but it will be through model building, you can have the end-users to change the range of values for the variables.
Agree with @ArunManickam
Optimizer does not fit this use case. The best way to replicate this what-if analysis is through boolean overrides.
Basically, supply a boolean for each of the drivers, like products sold. If the boolean is checked, then the profit calculation considers a separate line item which is a user input for number of products sold...2
hi there. I am happy to share a little sample I did - feel free to email [email protected]0