The Calculation Type page accepts input for the following items for a moving minimum calculation:
Measure
Select the measure for which you want to calculate a moving minimum.
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 minimum value for a measure over a rolling number of time periods.
An example of this calculation is:
Moving minimum sales for the last 3 months = the smallest Sales value for Jan, Feb, and March
Copyright © 2003, 2007, Oracle. All rights reserved.