View the original community article here
Last Tested: Jan 21, 2019
When you do a rank in table calculations it will show you the rank in descending order so the largest value of the field being ranked as number one. Like so:
rank(${price}, ${price})
Price | Price Rank |
$5 | 3 |
$28 | 1 |
$13 | 2 |
To see the rank in ascending order, you can simply make the numbers negative, so that they sort the opposite way:
rank((-${price}, (-${price}))
So you can see this:
Price | Price Rank |
$5 | 1 |
$28 | 3 |
$13 | 2 |
This content is subject to limited support.