The Calculation Type page 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:
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.
The formula for this calculation is:
(Current Value - Previous Value)
This formula is used to return the difference between the current value of a measure and the value of that measure from a prior period.
An example of this calculation is:
Difference = Sales June 2001 - Sales June 2000
Copyright © 2003, 2007, Oracle. All rights reserved.