From the Display Value of drop down list, the user has option to choose between the following:
- Variance (Default): Variance value will be displayed as (Parameter0 - Parameter 1) or (Parameter0 - Parameter 1) / ABS(Parameter 1) (in case of relative variance)
- Base: Variance value will be displayed as Parameter 0
- Reference: Variance value will be displayed as Parameter 1
- Better/Worse variance representation can be used to display positive variance with positive sign and negative variance with minus sign.
Example
Variance Settings
In case a report uses a percent calculation in a row and a percent variance in the column as given example:
In the image shown above, the gross margin % variance is shown incorrectly because it is calculating the percent difference between two percentages. Therefore, the variance settings can be used to display the absolute value as seen below:
With the result shown below:
, the percent variance will be calculated incorrectly.
As displayed below:
Gross Margin % row 1: is showing a VAR% ( Gross Margin % VAR / Gross Margin parameter0)
Gross Margin % row 2 (with percent point activated):is showing a VAR% ( Gross Margin% parameter0 - Gross Margin% parameter1)
Percent points can be activated on the specific row or column list.
In this example the row list is used to activate the percents points by setting the following settings in the variance settings.
