4 Replies Latest reply on Nov 1, 2016 12:19 PM by Shawn Wallwork

    Rounding to the hundredth or tens place for large numbers

    victor chan

      I have a number in the hundreds of thousands.

       

      It looks neater when looking at a lot of numbers to at least round the last digit. But I can't get this to work with commas, I can get decimals to behave when Tableau thinks it is in the thousands, but not with commas. Any ideas? Ideally, I would do this in formatting and not as a calculation as that would be many calculations to modify. I just can't get the Tableau number format to understand I want one digit and not three when entering a "0" or "#" in the custom formats.

       

       

      Here is an example of what I mean:

      #,##0;-#,##0

       

        

      is the same as:

         #,0;-#,##0

       

      Even though two "#"s have been removed after the first comma, it is still recognizing as a thousands precision.

       

       

      At which point it looks like this (with the before mentioned format of #,.0;-#,##0):

      What gives? It only recognizes it with decimals. Then I can add two dummy 0s under quotation marks of "00":

         #,.0"00";-#,##0

      How can I get this decimal behavior with commas?

       

      Thanks in advance.

      Victor.