2 Replies Latest reply on Mar 8, 2016 1:43 AM by Sankarmagesh Rajan

    Format numbers to automatically divide by thousands or millions

    Dave Weaver

      I could not believe this when I found it purely by accident. If you have ever wanted to divide your number by 1000 or a million before displaying it, no need to create another measure that does your division and rounding, you can simply format your number as custom with the following:

       

      eg. say you want to show 1,234,567.89 in thousands  or millions

       

      Custom format: 0,0.00,K

       

      will appear as 1,234.57K

       

      Custom format: 0,0.00,,M

       

      will appear as 1.23M

       

      That trailing comma, or commas, does the magic. You can divide by billions too by adding a third comma.

       

      I was so happy to find this while making a typo in my number formatting

      Dave