Percent Rank


The PERCENTRANK function calculates the percent rank for each value in a set of input values. Specifically, the function computes the percentage of all input values that are less than a given input value. Percent Rank values range between 0 and 1.

Percent Rank
Percent Rank

The PERCENTRANKGROUP function can be optionally used to calculate the percent rank for each value in sets of input values grouped by the specified hierarchies.

1. Syntax

Percent rank:


Percent rank group:


2. Input

The Percent Rank function requires the following input:

  • d0 - The set of data values for which the Percent Rank is calculated.

3. Parameters

The Percent Rank function requires the following parameters.

  • s0 - Indicates whether to include the two extreme percent values in the calculation. Default value is True.
  • Alignments... (One or More, Optional) – Hierarchy placeholders to be used as the alignment axis.

4. Output

The Percent Rank function generates the following output:

  • Percent Rank - The Percent Rank result set.

The Percent Rank Group function generates the following output:

  • Percent Rank Group - The Percent Rank Group result set.

5. See also

Dundas Data Visualization, Inc.
500-250 Ferrand Drive
Toronto, ON, Canada
M3C 3G8

North America: 1.800.463.1492
International: 1.416.467.5100

Dundas Support Hours:
Phone: 9am-6pm, ET, Mon-Fri
Email: 7am-6pm, ET, Mon-Fri