PowerCenter
- PowerCenter 10.5.6
- All Products
MOVINGAVG(numeric_value,rowset[,filter_condition] )
Argument
| Required/
Optional
| Description
|
---|---|---|
numeric_value
| Required
| Numeric datatype. The values for which you want to calculate a moving average. You can enter any valid transformation expression.
|
rowset
| Required
| Must be a positive integer literal greater than 0. Defines the row set for which you want to calculate the moving average. For example, if you want to calculate a moving average for a column of data, five rows at a time, you might write an expression such as: MOVINGAVG(SALES, 5) .
|
filter_condition
| Optional
| Limits the rows in the search. The filter condition must be a numeric value or evaluate to TRUE, FALSE, or NULL. You can enter any valid transformation expression.
|
MOVINGAVG( SALES, 5 )
|
|
|
---|---|---|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|