KNOWLEDGE BASE

Number Values Remain Rounded to the Nearest Whole Number After Changing the Data Type To Number (Decimal)


Published: 12 Apr 2017
Last Modified Date: 14 Apr 2017

Issue

After changing the data type on a field to Number (Decimal) from Number (Whole) on an extracted connection, and then either refreshing the extract or removing the extract; the data remains rounded up to the nearest whole number despite the data type showing as Number (Decimal).

Environment

Tableau Desktop

Resolution

On a live connection, re-select Number (Decimal) for the data type. 

If there are many fields that need to be reset, then do the following:
  1. Create a new connection to the same data source in the same workbook.
  2. Ensure that the necessary measures are being imported as Number (Decimal).
    • For more information about changing the data type for a field, please see the "Change the data type for a field in the Data Source page" section of the following entry of the online Product Help guide: Data Type
  3. Extract the new data connection. 
  4. Replace the old extract with the new extract.
    • For detailed directions on replacing data sources, see the following entry of the online Product Help guide: Replace Data Sources.
       

Cause

When the data is saved in the extract as Number (Whole), aka the actual values in the extract are rounded up to whole numbers, changing the data type will not change the values in the extract.
Did this article resolve the issue?