Variance Threshold Formats

You can specify the threshold format in the following ways:

In absolute values “-5;5”
In percentage values “-9%;9%”
As combination of absolute and percentage values “-9%, -5;9%,5”
As 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
The user can specify decimal values like “-9.9%, -5.5;9.9%,5.5”
If the absolute and percentage thresholds intervals do not intersect for the examined value then it is treated as neutral.
If the percentage examined variance is less than lower percentage threshold value or the absolute examined variance is less than lower absolute threshold value, then it is treated as negative. Otherwise the variance is treated as neutral. If the valuation of the item is Negative, then it will be treated as positive.
If the percentage examined variance is greater than upper percentage threshold value or the absolute examined variance is greater than upper absolute threshold value then it is treated as positive. Otherwise the variance is treated as neutral. If the valuation of the item is Negative, then it will be treated as negative.
If the examined variance doesn't fulfil the above rules then it is treated as neutral
If the valuation of the item is Negative than the threshold is mirrored around zero. E.g. “-9%, -5;8%,6” turns “-8%, -6;9%,5”

Examples

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 one of the values missing “-9%;9%,5”