Page History

Anchor
top top

Table of Contents
class contents

Overview

Styleclass
Class topLink
top

‘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.

Planning Your What if

Styleclass
Class topLink
top

Firstly you will have to define the columns that you wish to have as the output to your scenario. You will need to understand the major calculations you wish to apply including the input variables and their potential inputs.

...

Where the < Field > represents user parameters that you want the user to input.

Building your Formulas

Styleclass
Class topLink
top

To build a ‘What if Analysis’ formula you must have ‘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.

...

Defining User Prompt Formatting

Styleclass
Class topLink
top

Once your formulas have been defined you can drag these onto the report. You will note that any parameters included in those calculations will now appear in the filters section of your report data. This is because the parameter is treated somewhat like a user prompt filter.

...

Running your What if Scenario

Styleclass
Class topLink
top

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.

horizontalrule

Styleclass
Class topLink
top