Page History

...

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.

...

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

...

Click on the Filters tab at the top of the page and select the parameter you wish you format. From here you will be able to edit the parameter options such as name and format etc.

Image Removed 

 

Running your What if Scenario

...

horizontalrule

Styleclass
Class topLink
top