PERCENTILE

Syntax

PERCENTILE (Dimension, Values, Percentile, {Type}, {Condition})

Description

The PERCENTILE function returns a percentile of Values. The Percentile argument sets which percentile is calculated. If Type is zero or omitted, PERCENTILE calculates a population percentile; otherwise, PERCENTILE calculates a sample percentile. If Condition is omitted, the function uses all Values. If Condition is included, the function uses only those Values for which Condition is true.

Example

Suppose that an analytic model contains a data cube called SCORES that uses dimensions called STUDENTS and TESTS.

The following formula calculates the 90th percentile of the scores for each test:

PERCENTILE(STUDENTS, SCORES, 90%)

The following formula calculates the 50th percentile of the first 10 students:

PERCENTILE(STUDENTS, SCORES, 50%, MEMBER(STUDENTS) <= 10)

This formula calculates the 50th percentile (also knows as median) of the first 10 students for each test.