Knowledge Drop

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

  • 6 April 2021
  • 0 replies
  • 442 views

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!

Reply