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

    Change number format to thousand

    kalyan prasunna



      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