4 Replies Latest reply on Aug 22, 2016 5:08 AM by harris.tsr

    Prevent rounding numbers in $K

    harris.tsr

      Hi Everyone,

       

      Came across with an odd situation. I use some amounts from a spreadhseet for example:  Amount X = 4700, divided by 1000 to show it as 4.7 (because the header indicates $K) then, I divide this amount by a coefficient i.e. 50 and then, I need to times this amount x100.

      For example: ((4700/100)/50)*100 = 9.4. This 9.4 is what I want to display in the dashboard, but instead, Tableau rounds it down to 9. I have checked the number format both automatic an custom and doesn't seem that something needs to be changed. I don't want to set the units in K, because I indicate the $K in the header.

       

      The cells format that contain the numbers in the spreadhseet is "General" but there is a reason for that as well, so it would be good to remain General

       

      Is there any ideas how to show the reuslt of the calculation in the view I described?

       

      Many thanks