Function Index


Rank the rows in the table by percentile using the input column.


RankPercentile(<column>,<direction ”asc” | “desc”>)

column (required) The column used to order the table. The input column can be numbers, dates or text.

direction (optional) The direction to sort the input column. Default is to sort ascending.

NOTE: The percentile is a number between 0 and 1. The last row is always 1 and the first is 0, unless there is only 1 row or there is a tie for the top most value. To display the result as percentages as opposed to numbers, change the column formatting from Automatic to Percent.


RankPercentile([Population by State])
  • This will assign the state with the smallest population rank 0, the largest population will be assigned rank 1.
RankPercentile([Population 2010])
RankPercentile([COUNTY - Count])