5 Replies Latest reply: Feb 29, 2016 5:20 PM by Marco Wedel RSS

    Round table

    Eric Suykerbuyk

      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