Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 11 Next »

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



  • 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:

  1. In absolute values “-5;5”
  2. In percentage values “-9%;9%”
  3. To use both absolute and percentage variances (When doing so there is the option to use 'And' or 'Or')
  4. 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
  5. Decimal values like “-9.9%, -5.5;9.9%,5.5” can be specified
  6. The valuation of the account is taken into consideration (Revenue is counted as positive and Costs as negative)

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 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.



  • No labels