More actions
jrfconvert import |
No edit summary |
||
| (3 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
{{HelpFiles}} | |||
| |||
====percentile==== | ==== percentile ==== | ||
Calculate the 100-quantiles. | Calculate the 100-quantiles. | ||
'''Syntax''' | '''Syntax''' | ||
percentile(''dcsColumn, pct'') | percentile(''dcsColumn, pct'') | ||
'''Arguments''' | '''Arguments''' | ||
''dcsColumn'': | ''dcsColumn'': is a numeric dcs column (column whose data type is Number) | ||
''pct'': an integer number. (0 < pct < 100) | ''pct'': an integer number. (0 < pct < 100) | ||
'''Example''' | '''Example''' | ||
percentile(C1, 25) where C2 == 1; | ''number n = percentile(C1, 25) where C2 == 1; '' | ||
'' | ''print(n); //return percentile value'' | ||
Version 5.2 | '''Availability''' | ||
__NOTOC__ | |||
<!-- imported from file: 762.htm--> | Version 5.2 __NOTOC__ <!-- imported from file: 762.htm--> | ||
[[Category:Functions_Used_in_where_Expressions]] | |||
Latest revision as of 10:41, 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;
print(n); //return percentile value
Availability
Version 5.2