Page History
...
Styleclass | ||
---|---|---|
| ||
'What ‘What if analysis' 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.
...
For example if you wish to conduct a 'What if' ‘What if’ on Sales Revenue you may create a calculation based on the following parameters:
...
Styleclass | ||
---|---|---|
| ||
To build a 'What ‘What if Analysis' Analysis’ formula you must have 'Parameters' ‘Parameters’ defined on your view. A parameter is a special type of input field that is used to capture a value from the user and to use that value for calculations and filters.
...
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.
...
Option | Description |
---|---|
Description | Give the parameter a usable name - – this will be displayed on the user prompt. |
Default Value | The default value used to ensure that the parameter can work even if the user doe not immediately enter a value. |
Display Type | Choose how you want the user prompt to be displayed. You can use wither a text box, Dial or slider. |
Colour | If using a slider or dial choose the colour of the Slider or Dial |
Min | If using a slider or dial choose the minimum allowable value. |
Max | If using a slider or dial choose the maximum allowable value |
...