PowerCenter
- PowerCenter 10.4.0
- 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 )