Skip to main content
Calculates the relative rank of each row within a partition as a percentage, ranging from 0 to 1. Category: window Syntax: 
PercentRank([column])
Returns: Float Context Filtering: ✗ No

​
Parameters

NameTypeRequiredDescription
columncolumn✓ YesThe column to calculate percent rank for

​
Validation

  • Minimum parameters: 1
  • Maximum parameters: 1

​
Examples

PercentRank([Sales])
Returns the relative rank of each sales value as a percentage. The lowest sales gets 0.0, the highest gets 1.0, and middle values are distributed proportionally. 
PercentRank([Score])
Calculates the percentile rank for each score. A result of 0.75 means the score is higher than 75% of other scores. Result: Values range from 0.0 to 1.0
  • Rank - Assigns rank with gaps
  • DenseRank - Assigns rank without gaps
  • CumeDist - Calculates cumulative distribution
  • RowNumber - Assigns sequential row numbers
  • Ntile - Divides rows into groups
Last modified on March 13, 2026