KNOWLEDGE BASE

Adjustment of Number Format Appears to Round Numbers Incorrectly


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

Issue

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.

Environment

Tableau Desktop

Resolution

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.

Cause

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?