The middle value when the number of records is odd; the mean of the two middle values when the number of records is even.
median APPVAL
median APPVAL (STATE in 'VA')
median 31 36 53 53 67
median 2 3 1 5
median (2 3 1 5)(1 0 1 1)
median NumField (Weight|SelectionStatement)
Name | Data Type | Input Type | Description | Optional | Default |
---|---|---|---|---|---|
NumField | Numeric | Field | No | ||
SelectionStatement | Boolean | Field, Constant | Yes | ||
Weight | Numeric | Field | Yes |
Type: Numeric
Median or middle value