Variance Calculation

The Calculation Type panel accepts input for the following items for a variance calculation:

Base measure -- Select the measure that you want to subtract from the target measure.

Target measure -- Select the measure that you want to use for comparison with the base measure.

Number Format -- Select one of the default number formats to use for this calculation or choose Options to specify another format.

Options -- Displays the Number Format dialog, in which you can specify a format for the calculation.

This type of calculation applies to measures only.

Formula Description

Formula

The formula for this calculation is:

Target-Base

Description

This formula is used to calculate the difference between a base measure and a target for that measure.

Example

An example of this calculation is:

Sales Variance = Sales-Sales Forecast