3 Replies Latest reply: Sep 2, 2013 3:51 AM by Paul Yeo RSS

    How to make my raw data value display as 2 digit decimal

      Hi All

       

       

      I have a field = S_Price

       

      From the link i get the below load script to get 2 decimal.      http://community.qlik.com/thread/90550


           num(trim(S_Price),' #,##0.00') as LIST_PRICE_,

       

      Above load script i am able to make the raw data display 2 decimal point,.

       

       

           S_Price/1.4 as LIST_PRICE

       

       

      Now i need to convert the S_Price from US to SGD currency by divide by 1.4

       

       

      May i know how to make it display 2 decimal point ?

       

       

      Paul