PowerCenter
- PowerCenter 10.5
- All Products
MEDIAN(numeric_value[,filter_condition] )
Argument
| Required/
Optional
| Description
|
---|---|---|
numeric_value
| Required
| Numeric datatype. Passes the values for which you want to calculate a median. 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.
|
MEDIAN( SALARY )
MEDIAN( SALES, ITEM = 'Stabilizing Vest' )
|
|
---|---|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|