Variance

Owned by
Migration
Last updated: Jun 02, 2015 by
Erik Stalpers (Deactivated)
1 min read

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

From the DisplayValueof dropdown 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 also

How_can_I_apply_conditional_formatting?