Knowledge Drop

How do I change the order of my rank on a table calculation? (ascending, descending)

  • 6 April 2021
  • 0 replies

Userlevel 5

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.                


0 replies

Be the first to reply!