KNOWLEDGE BASE

Rank() Function Show Different Ranks for the Same Value


Published: 18 Sep 2020
Last Modified Date: 10 Dec 2020

Issue

The RANK() function shows two unique ranks for the same integer number like below:

User-added image

Environment

  • Tableau Desktop

Resolution

The resolution is to make a calculation field to round the numbers to the values that are shown in the view.
RANK(ROUND(AVG([Sales])))

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)

User-added image
Did this article resolve the issue?