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

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

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: