PowerCenter
- PowerCenter 10.5.1
- All Products
AVG(numeric_value[,filter_condition] )
Argument
| Required/
Optional
| Description
|
---|---|---|
numeric_value
| Required
| Numeric datatype. Passes the values for which you want to calculate an average. You can enter any valid transformation expression.
|
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.
|
AVG( WHOLESALE_COST, ITEM_NAME='Flashlight' )
|
|
---|---|
|
|
|
|
|
|
|
|
|
|
|
|
|
AVG( QTY * PRICE - DISCOUNT )