- 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%”
- The option to To use both absolute and percentage variances When using both percentage and absolute (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
- The user can specify decimal Decimal values like “-9.9%, -5.5;9.9%,5.5”
- 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.
- 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 |
Examples
The examples below represent the same report with different threshold formats applied.
Example 1: Variance Threshold in absolute values “-50005;5000”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%,-50005;5000”5”
When the variance calculation is outside the ranges of -9% - 9% or -5000 5 - 5000 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%,-50005;5000”5”
When the variance calculation is outside the ranges of -9% - 9% and -5000 5 - 5000 5 it should be Negative or Positive otherwise it is Neutral.
