Loading

Rank() Function Show Different Ranks for the Same Value

Udgivelsesdato: Apr 29, 2025
Beskrivelse

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

User-added image

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
Løsning
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])))
Vidensartikelnummer

001496508

Vedhæftede filer

Rank Issue_v2018.1.twbx

2083 KB

 
Indlæser
Salesforce Help | Article