The PERCENTILE function returns a scalar value below which the specified percentage of input data values fall. The closest input value that satisfies the condition is returned.


1. Syntax


2. Input

The Percentile function requires the following input:

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

3. Parameters

The Percentile function requires the following parameters:

  • s0 - The percentage value used in Percentile calculations. Default value is 80.
  • s1 - Indicates whether to include the two extreme percent values in the calculation. Default value is True.
  • s2 - The methodology used for calculating the percentile. The methodology used for percentile. The default one uses the percent rank computation with a value of 0, while the direct computation method uses value 1.
  • Alignments... (One or More, Optional) – Hierarchy placeholders to be used as the alignment axis.

4. Output

The Percentile formula generates the following output:

  • Percentile - A single value representing the specified percentile.

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