Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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.

CONTENT

Table of Contents

This  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
  • Homepage
  • Value Tree Homepage
    • 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. As combination of absolute and percentage values “-9%, -5;9%,5”
    4. 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
    5. The user can specify decimal values like “-9.9%, -5.5;9.9%,5.5”
    6. If the absolute and percentage thresholds intervals do not intersect for the examined value then it is treated as neutral.
    7. 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.
    8. 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.
    9. If the examined variance doesn't
    fulfil
    1. fulfill the above rules then it is treated as neutral
    2. 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”

    Image Removed

    Image Added

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

    Image Removed

    Image Added

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

    Image Removed

     

    Image Added