Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
try this.
round(LIST_PRICE,0.01)
Regards,
Kaushik Solanki
Hi,
try this.
round(LIST_PRICE,0.01)
Regards,
Kaushik Solanki
Hi Kau
Thank you for your sharing , notice that your not work , after play around , i found below does work :-
num(trim(S_Price)/1.4,' #,##0.00') as LIST_PRICE
Paul
Hi Kau
I am sorry ,after put my code into test , i notice your code work , mine is not work.
Paul