We are doing sales planning with what-if analysis. For what-if analysis purpose we have created a driver model in which all the drivers affecting the sales revenue are mapped. All these drivers impact on the sales revenue plan, the Main Model for sales planning contains the sales quantity only.
Sales revenue can be obtained through multiplication of sales quantity in main model with the prices in the driver model.
I have performed the calculation within one model, but i am not clear about the calculation on the data from other model.
Can any one suggest the steps to be followed in this case, and code to be used for this purpose.