Calculate the continuous k-th percentile value for a column or group.


PercentileCont(numbers, k)

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

k (required) Percentile fraction between 0 and 1.

NOTE: Interpolation is done between adjacent values if needed.



PercentileCont([Score], 0.7)
  • Calculates the 70th percentile of scores. If the column values are 2, 4, 6, 8, and 10, the result would be 7.6.

See Also

Was this article helpful?

Anything else?

Our customer support team is here to help.

Contact Us