Find the nth percentile of a set of data. The 25th percentile is the first quartile; The 50th percentile is the median; The 75th percentile is the third quartile.
ptile CURBAL 50
ptile CURBAL 25
ptile CURBAL 80
ptile CURBAL 30
ptile CURBAL 50 (RATETYPE in 'A')
ptile NumField nn (SelectionStatement∣Weight)
| Name | Data Type | Input Type | Description | Optional | Default |
|---|---|---|---|---|---|
| NumField | Numeric | Field, Constant | No | ||
| nn | Numeric | Field, Constant | No | ||
| SelectionStatement | Boolean | Field | Expression to select records that will be applied to the calculation. | Yes | 1 |
| Weight | Numeric | Field, Constant | No |
Type: Numeric
nth percentile of the field