6 Replies Latest reply: May 23, 2013 4:05 AM by Rhea Pama RSS

    NUM format

      Hi,

       

      I set this format in a field in my script: Num(FIELD_VALUE, '#,##0')

      If FIELD_VALUE is 8.00 qlikview correctly formats it to 8.

      But if FIELD_VALUE is 1, the format becomes 1.0000 which is wrong.

      The value should remain 1.

       

      Any idea how to overcome this?

       

      Thanks.