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 ?