Function Index

PercentileDisc

Find the discrete k-th percentile value for a column or group.

Usage

PercentileDisc(<number>,<k>)

number (required) The column of numbers to be searched.

k (required) Percentile fraction between 0 and 1.

Examples

PercentileDisc([Score], 0.7)
  • If the column values are 2, 4, 6, 8, and 10, the result would be 8.