topic Eliminate negative zero in QlikView https://community.qlik.com/t5/QlikView/Eliminate-negative-zero/m-p/1192040#M385080 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P></P><P>When a value is rounded off to two decimals, -0.0001 is rounding of to -0.00 it should be 0.00.</P><P></P><P>When we round in excel, -0.0001 is rounded to 0.00 or 0. I need same result in qlik also.</P></BODY></HTML> Thu, 29 Sep 2016 06:43:58 GMT 2016-09-29T06:43:58Z Eliminate negative zero https://community.qlik.com/t5/QlikView/Eliminate-negative-zero/m-p/1192040#M385080 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P></P><P>When a value is rounded off to two decimals, -0.0001 is rounding of to -0.00 it should be 0.00.</P><P></P><P>When we round in excel, -0.0001 is rounded to 0.00 or 0. I need same result in qlik also.</P></BODY></HTML> Thu, 29 Sep 2016 06:43:58 GMT https://community.qlik.com/t5/QlikView/Eliminate-negative-zero/m-p/1192040#M385080 2016-09-29T06:43:58Z Re: Eliminate negative zero https://community.qlik.com/t5/QlikView/Eliminate-negative-zero/m-p/1192041#M385081 <HTML><HEAD></HEAD><BODY><P>Use the round function: round(sum(b),0.01)</P><P>And if you want to display zero values then disable the Suppress Zero-Values option on the Presentation tab.</P></BODY></HTML> Thu, 29 Sep 2016 06:46:00 GMT https://community.qlik.com/t5/QlikView/Eliminate-negative-zero/m-p/1192041#M385081 Gysbert_Wassenaar 2016-09-29T06:46:00Z