The Calculation Type page accepts input for the following items for a moving average calculation:
Measure
Select the measure for which you want to calculate a moving average.
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 dimension.
Include previous
Enter the number of periods to be used for the calculation.
This formula is used to return the average value for a measure over a rolling number of time periods.
An example of this calculation is:
Moving average sales for the last 3 months = (Jan Sales + Feb Sales + March Sales)/3
Copyright © 2003, 2007, Oracle. All rights reserved.