Variance Threshold Formats

You can specify the threshold format in the following ways:

In absolute values “-5;5”
In percentage values “-9%;9%”
To use both absolute and percentage variances (When doing so there is the option to use 'And' or 'Or')
As a combination of absolute and percentage values with one of the values missing “-9%;9%,5” or “-9%,-5;9%” or “-5;9%,5”. If the value is missing then it is treated as 0
Decimal values like “-9.9%, -5.5;9.9%,5.5” can be specified
The valuation of the account is taken into consideration (Revenue is counted as positive and Costs as negative)

Suppress Variance Settings

There are different options to suppress the variance:

Option	Result
Never	Variance is not suppressed
Always	Variance is always suppressed
Zero Base	Variance is suppressed when the base is zero
No Base	Variance is suppressed when there is no base in it
Zero Ref	Variance is suppressed when the reference is zero
No Ref	Variance is suppressed when there is no reference in it
Zeros	Variance is suppressed when the result is zero

The examples below represent the same report with different threshold formats applied.

Example 1: Variance Threshold in absolute values “-5;5”

Example 2: Variance Threshold in percentage values “-9%;9%”

Example 3: Variance Threshold as combination of absolute and percentage values with the OR function “-9%;9%,-5;5”

When the variance calculation is outside the ranges of -9% - 9% or -5 - 5 it should be Negative or Positive otherwise it is Neutral.

Example 4: Variance Threshold as combination of absolute and percentage values with the AND function “-9%;9%,-5;5”

When the variance calculation is outside the ranges of -9% - 9% and -5 - 5 it should be Negative or Positive otherwise it is Neutral.