Introduction

The Variance Threshold parameter is used to store threshold values. Variance Threshold can be represented in several formats, depending on the type of threshold values. This option is available for the following report templates:

CONTENT

Table of Contents

Financial Statement
Multi-Column
Waterfall
Multiple Scenario Analysis
Components
Ranking
Trends
Value Tree
Benchmark
Compare Trend
Home Page
Free Format Template

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”
The option to both absolute and percentage variances
When using both percentage and absolute there is the option to use 'And' or 'Or'
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 fulfill 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”