7 Replies Latest reply: May 5, 2015 3:37 PM by Vamsi Vandavasi RSS

    Change number format to thousand

    kalyan prasunna

      Hi

       

      I have values for measure as 100000, 2000000, 300000 etc. I want values to be resprented as 100k, 200k, 300k.

       

      I used expression like below but i am values like 100, 200 instead of 100k, 200k

       

      If(SUM([Vbl.Val./COCrcy]) >= 1000000,

         Num(SUM([Vbl.Val./COCrcy])/1000000, '#.##0 M'),

         Num(SUM([Vbl.Val./COCrcy])/1000, '#.##0 K')

        )

       

      Can you please let me know what i am missing

       

      Thanks