percentile
Returns a value, on a scale of one hundred, that indicates the percent of a distribution that is equal to or below the selected data items. The "<for-option>" defines the scope of the function. The "at" option defines the level of aggregation and can be used only in the context of relational datasources.
Syntax
percentile ( numeric_expression [ at expression { , expression } ]
[ <for-option> ] [ prefilter ] )
percentile ( numeric_expression [ <for-option> ] [ prefilter ] )
<for-option> ::= for expression { , expression }|for report|auto Example
percentile ( Sales 98 )Result
For each row, returns the percentage of rows that are equal to or less than the quantity value of that row.
Result data
| Qty | Percentile (Qty) |
|---|---|
| 800 | 1 |
| 700 | 0.875 |
| 600 | 0.75 |
| 500 | 0.625 |
| 400 | 0.5 |
| 400 | 0.5 |
| 200 | 0.25 |
| 200 | 0.25 |