Calculates the inclusive percentage rank of a value within a dataset to determine its relative position among other values.
The PERCENTRANKINC function returns the percentage rank of a value within a dataset using the inclusive method. It indicates the relative position of a value compared to other values and includes both the minimum and maximum values in the calculation.
PERCENTRANK is the legacy version of the PERCENTRANKINC function and works similarly. It can be used in place of PERCENTRANKINC for inclusive percentage rank calculations.
PERCENTRANKINC(array, x, [significance])The PERCENTRANKINC function syntax has the following arguments:
The result ranges from 0 to 1 (inclusive), where 0 represents the minimum value in the dataset and 1 represents the maximum value.
PERCENTRANKINC(10,20,30,40,50, 10)
// Returns 0
PERCENTRANKINC(10,20,30,40,50, 30)
// Returns 0.5
PERCENTRANKINC(10,20,30,40,50, 50)
// Returns 1
You can use the PERCENTRANKINC function to determine the relative standing of a value within a dataset for metrics such as sales, revenue, or performance scores.
PERCENTRANKINC
We used the SELECT function to select a range of columns from 1 to 4 for the 'Revenue' measure (2022 Revenue - 2025 Revenue)
Q1. How is PERCENTRANKINC calculated?
PERCENTRANKINC is calculated by determining the relative position of a value within a sorted dataset using the inclusive method, which includes both the minimum and maximum values in the calculation.
PERCENTRANKINC = (r-1) / (n-1)​
Where:
If the value does not exactly match an existing value, the result is obtained by interpolating between the surrounding values.
It returns a value between 0 and 1 (inclusive) representing the relative standing of the value in the dataset.
