3 Replies Latest reply: Jun 14, 2015 6:27 AM by ted soesanto RSS

    How to Showing Thousands in Qsense?

      Hi All,

       

      I wanna show the values in Text at Qsense in Millions even when the values goes to the Thousands, like for "500.000". i want to show it as "500 K".

      i have tried ==> Num(MyExpression/1000, '#,##0.##K') in Expression, but is not working,

      and if i use custom formatting, and  format pattern = '#.##0K' , if the data is null,it will show '0K', i wanna it still show '0'.

      can any one help me to achieve this.

       

      Best Regards,

      Ted