Function Index

RankPercentile

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

Usage

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.

Examples

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])