Adjustment of Number Format Appears to Round Numbers Incorrectly

Published: 15 Oct 2015
Last Modified Date: 13 Apr 2017


When adjusting the number of decimal places shown for a number, numbers might appear to round up or down incorrectly. For example, a number displayed as 40.5 might change to 40 when the formatting is changed to show zero decimal places.


Tableau Desktop


View the underlying data to verify the original number to ensure that it is being rounded correctly for the number format. For example, an original value of 40.48 would be correctly rounded to 40.5 if one decimal place were specified and 40 if zero decimal places were specified.


Tableau Desktop rounds numbers based on the original value in the database, following the "round up by half" convention. 
Did this article resolve the issue?