PERCENTILE

This function calculates a percent rank for each value satisfying the numeric expression argument. The percentile rank ranges are from 0 (1st percentile) to 1 (100th percentile), inclusive.The percentile is calculated based on the values in the result set.

Syntax: PERCENTILE(numExpr)

Syntax description

numExpr is any expression that evaluates to a numeric value.

Example: PERCENTILE ("Sales"."Rp Revenue")