1. Designing with Reports for Oracle Enterprise Performance Management Cloud
  2. Using Functions
  3. Mathematical Functions
  4. Variance
  5. Examples

Examples

Variance accepts cell, column, or row references only. For more information, see Row, Column, or Cell Reference Arguments.

Syntax Example

Sample syntax referencing a column:

Var ([A], [B])

Sample syntax referencing a row:

Var ([3], [4])

Sample syntax referencing a cell:

Var (Cell [3,A], [3,B])

In this example, the variance between column A (Actual) and column B (Budget) is calculated as: 

Var([A],[B])

This example produces the following report:


The table describes an example of the Variance function accepting cell, column, or row references.