3 Replies Latest reply on Jul 6, 2017 1:17 PM by Hari Ankem

    Decimal values are getting rounded up? Precision loss 9.1

    Victor Sanabia

      I have a custom query that returns a value: 1,234,102.75. How ever when I excute the query in tableau it shows up as 1,234,100.00. It's not rounding them all up the the nearest whole number either. Sometimes it rounds up to the nearest tenth place decimal point: 91,134.17 in the backedend shows up as 91,134.20.

       


      I tried googling this but only found threads on HOW TO round rather than possible reason I'm losing precision.

       

      The backed end is a Database with a Float 4 type and it shows up as a decimal type in Tableau.

       

      Any ideas on what could be causing thing precision loss?