Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am just starting to use/learn qlikview/SQL.
This is a part of my code
ODBC CONNECT TO prdax2012_mirror (XUserId is xx, XPassword is yy);
SQL SELECT ROUND(AMOUNTCURCREDIT,2) as CURCREDIT,
I would like to round my numbers in this table to 2 decimal digits. When I export the result in excel, some of the data has more than 2 decimals.
Any idea what I am doing wrong?
Regards
Eric
Hi,
maybe
LOAD ROUND(AMOUNTCURCREDIT,0.01) as CURCREDIT;
SQL SELECT AMOUNTCURCREDIT
hope this helps
regards
Marco
Hi,
maybe
LOAD ROUND(AMOUNTCURCREDIT,0.01) as CURCREDIT;
SQL SELECT AMOUNTCURCREDIT
hope this helps
regards
Marco
In addition to the suggestion from Marco some background: Preceding Load.
- Marcus
Hi Marco,
splendid. it works
Regards
Eric
Hi Marcus,
Thank you for the link, it helped me with understanding the logic of the answer of Marco.
Regards
Eric
glad it works.
please close your thread by marking an answer correct that solved your problem.
You can also mark answers helpful that delivered additional information.
thanks
regards
Marco