Select An Org
Rank() Function Show Different Ranks for the Same Value
Publish Date: Apr 29, 2025
Description
The RANK() function shows two unique ranks for the same integer number like below:
Cause
The values that appear to be the same in ranks are actually rounded to display without decimal numbers.(eg. "1500" shown in the view, while "1499.9750" are used in ranking)
Resolution
RANK(ROUND(AVG([Sales])))
Knowledge Article Number
001496508
Did this article solve your issue?
Let us know so we can improve!
