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