| Anchor | ||||
|---|---|---|---|---|
|
| Table of Contents | ||
|---|---|---|
|
Overview
‘What if analysis’ is a method of creating calculated fields which allow you to test scenarios. For example if you wish to create a budget formula but you are unsure of the revenue for the following period you could use calculations with a number of input parameters to define the budget value.
...
If you wish to apply % changes to your calculations then ensure you assume the user will input values where 100% = 100 and not 1. This is because some of the input options work in whole number increments and not decimals.
Note: you can only use a single parameter for a single input. For example a parameter field that is to be used for % Price Change cannot be used to also Capture % Change in Sales Volume unless you wish both values to be identical.
...
Once all your calculations and parameters have been defined continue to the report output page. Here you will see the parameters being presented.
If you change the parameters from the default values using the input mechanisms presented you will see the data in your report updated in your calculated field columns with new values.