Difference from Prior Period Calculation

The Calculation Type panel accepts input for the following items for a difference from prior period calculation:

Measure -- Select a measure or a dimension member for which you want to calculate the difference from a prior period.

Over -- If there is more than one time dimension, then a box appears to allow the selection of the proper time dimension. Otherwise the default time dimension is used.

In -- Select the hierarchy for the specified time dimension.

From -- Choose one of the following items to indicate time periods:

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.

Formula Description

Formula

The formula for this calculation is:

(Current Value - Previous Value)

Description

This formula is used to calculate the difference between a value from the current time period and a value from a previous time period.

Example

An example of this calculation is:

Difference = Sales June 2001 - Sales June 2000