Calculation Wizard: Percent difference from prior period calculation

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

Measure

Select a measure or a dimension member for which you want to calculate the percent difference from the 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.

Select the hierarchy for the specified dimension.

From

Choose one of the following items to indicate time periods:

Year ago. Requests a value from the previous year.
Period ago. Requests a value from the previous period.
Number of periods or years ago. Requests a value from a specified number (entered in the number box) of periods ago; also can indicate levels of time such as Year, Quarter, or Month.

Formula Description

The formula for this calculation is:

(Current Value - Previous Value) /ABS( Previous Value)

Description

This formula is used to return the percentage difference between the current value of a measure and the value of that measure from a prior period.

Example

An example of this calculation is:

Percent Difference = (Sales June 2001 - Sales June 2000)/ABS(Sales June 2000)