Difference between revisions of "Percentile"
| Line 18: | Line 18: | ||
'''Example''' | '''Example''' | ||
| − | percentile(C1, 25) where C2 == 1; | + | number n = percentile(C1, 25) where C2 == 1; |
'''Availability''' | '''Availability''' | ||
Revision as of 10:47, 20 December 2011
percentile
Calculate the 100-quantiles.
Syntax
percentile(dcsColumn, pct)
Arguments
dcsColumn: is a numeric dcs column (column whose data type is Number)
pct: an integer number. (0 < pct < 100)
Example
number n = percentile(C1, 25) where C2 == 1;
Availability
Version 5.2
