5 Replies Latest reply on Oct 13, 2013 12:24 PM by . Indumon

    Tableau Truncating ending numbers and replacing with 0's

    Daniel Seisun

      I have an excel file with some very long ID's and some information about the record. When Tableau renders the data it replaces the trailing 3 numbers with 0's. As an example

       

      ID's that look like:

      379439598738210816

      380302791077421057

      379449607887290368

       

      are being rendered as:

      379439598738210000

      380302791077421000

      379449607887290000

       

      I think this has something to do with tableau bringing the data in like this under the hood:

      3.7964423673743e+017

      3.79708399849439e+017

      3.79708767782179e+017

      3.80149273402167e+017

      and truncating the trailing decimals, but I'm not sure how to solve for this