Versions Compared

Version Old Version 8 New Version 9
Changes made by

Former user

Jeroen de Soeten (Deactivated)

Saved on

Key

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

Introduction

The Variance formula allows you to Calculate the variance of two values. The Variance can be expressed as an absolute number or as a relative value.

The syntax of this formula is: (Parameter0 - Parameter1) or in the case of a relative variance (Parameter0 - Parameter1) / Parameter1

CONTENT

Table of Contents

From the Display Value of drop down list, the user has option to choose between the following:

  • Variance (Default): Variance value will be displayed as (Parameter0 - Parameter 1) or (Parameter0 - Parameter 1) / Parameter 1 (in case of relative variance)
  • Base: Variance value will be displayed as Parameter 0
  • Reference: Variance value will be displayed as Parameter 1
  • Better/Worse variance representation can be used to display positive variance with positive sign and negative variance with minus sign.

 


Example 

See

Variance Settings

In case a report uses a percent variance in the column as given example:

Image Added

In the image shown above, the gross margin % variance is shown incorrectly because it is calculating the percent difference between two percentages. Therefore, the variance settings can be used to display the absolute value as seen below:

Image Added

With the result shown below:

Image Added


 See also

How_can_I_apply_conditional_formatting?