I'm having a problem where Tableau's ROUND() function is not consistently rounding up for values of x.5.
The data in the attached workbook consists of the ID, Number, and Rounded in Excel fields.
- All of what is entered into the Number field in Excel is shown in the Number column.
- The Rounded in Excel field in Excel uses the formula ROUND([Number cell ref],0) and produces expected results.
-The Number (using custom format) column shows the Number field and a custom Format to not show any decimal places. This rounds up as expected.
-The Rounded in Tableau column is a calculated field with the formula ROUND([Number],0) and it fails on 0.5 and 3000.5, but works on 1.5.
Does anyone know why this is?
Jonathan there is definitely something weird going on between Tableau and Excel. Here's my Excel file:
And here's what it looks like in Tableau:
I'm not doing any rounding in either file, just displaying the raw data. Some number go long, some don't.
Become a Viz Whiz on the Forums!
Support the Community and master Tableau.
Retrieving data ...