Input for Actual and Formulas for Other Versions(e.g. Budget, Forecast1, Forecast2) for entire model

Star

Hi

In a scenario where Actuals are input and formulaes are defined for other versions e.g. Budget, Forecast1, Forecast2) for the entire model, how can the SYS module be created for versions so that they can be referenced in Calculation or other modules?

 

 

einas.ibrahim

Hi again @Star 

To make sure I understand what you are trying to accomplish, let me rephrase your question:

1. Your target module has data by version
2. The Actuals data is inputted by the user while the data for the other versions are calculated? ( that's an unusual scenario since usually Actuals are already calculated in a transaction system while budget and forecast are user inputs!)
3. You want to know how can you have a formula to calculate the forecast and budget data while still allow the user to input the actual versions data.
   
   
   

If that's the case then all you have to do is in the blueprint scroll to the right until you find a column titled formula scope (or something like that) and select All but Actual.
which basically tells Anaplan, apply the formula in this line items to all the versions except for the actual version, This way when the Actual version is selected the formula won't apply and the user can input the data.