Page History
Anchor | ||||
---|---|---|---|---|
|
Table of Contents | ||
---|---|---|
|
Overview
Styleclass | ||
---|---|---|
| ||
Planning Your What if
Styleclass | ||
---|---|---|
| ||
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:
...
Where the < Field > represents user parameters that you want the user to input.
Building your Formulas
Styleclass | ||
---|---|---|
| ||
...
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.
Defining User Prompt Formatting
Styleclass | ||
---|---|---|
| ||
...
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 |
Running your What if Scenario
Styleclass | ||
---|---|---|
| ||
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.
horizontalrule |
---|
Styleclass | ||
---|---|---|
| ||