topic Re: Issue with rounding in QlikView https://community.qlik.com/t5/QlikView/Issue-with-rounding/m-p/1005019#M948905 <HTML><HEAD></HEAD><BODY><P>You might also be able to use If statement:</P><P></P><P><STRONG>If(Round(Frac(sum(Cost)), 0.01) &lt;&gt; 0.99, Sum(Cost))</STRONG></P><P><STRONG><BR /></STRONG></P><P><STRONG><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/108868_Capture.PNG" style="height: auto;" /><BR /></STRONG></P></BODY></HTML> Sun, 13 Dec 2015 14:33:18 GMT sunny_talwar 2015-12-13T14:33:18Z Issue with rounding https://community.qlik.com/t5/QlikView/Issue-with-rounding/m-p/1005016#M948902 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have a small / requirement in rounding.</P><P>I don't want to show records ending in .99. Can someone please share a sample expression.</P><P></P><P>Thank you in advance.</P><P></P><P>Regards,</P><P>Sachin</P></BODY></HTML> Sun, 13 Dec 2015 13:48:40 GMT https://community.qlik.com/t5/QlikView/Issue-with-rounding/m-p/1005016#M948902 2015-12-13T13:48:40Z Re: Issue with rounding https://community.qlik.com/t5/QlikView/Issue-with-rounding/m-p/1005017#M948903 <HTML><HEAD></HEAD><BODY><P>Try this expression instead: sum({&lt;Item={"=round(frac(sum(Cost)),0.01)&lt;&gt;0.99"} &gt;}Cost)</P></BODY></HTML> Sun, 13 Dec 2015 14:12:34 GMT https://community.qlik.com/t5/QlikView/Issue-with-rounding/m-p/1005017#M948903 Gysbert_Wassenaar 2015-12-13T14:12:34Z Re: Issue with rounding https://community.qlik.com/t5/QlikView/Issue-with-rounding/m-p/1005018#M948904 <HTML><HEAD></HEAD><BODY><P>Thank u Sir. It worked.</P></BODY></HTML> Sun, 13 Dec 2015 14:29:56 GMT https://community.qlik.com/t5/QlikView/Issue-with-rounding/m-p/1005018#M948904 2015-12-13T14:29:56Z Re: Issue with rounding https://community.qlik.com/t5/QlikView/Issue-with-rounding/m-p/1005019#M948905 <HTML><HEAD></HEAD><BODY><P>You might also be able to use If statement:</P><P></P><P><STRONG>If(Round(Frac(sum(Cost)), 0.01) &lt;&gt; 0.99, Sum(Cost))</STRONG></P><P><STRONG><BR /></STRONG></P><P><STRONG><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/108868_Capture.PNG" style="height: auto;" /><BR /></STRONG></P></BODY></HTML> Sun, 13 Dec 2015 14:33:18 GMT https://community.qlik.com/t5/QlikView/Issue-with-rounding/m-p/1005019#M948905 sunny_talwar 2015-12-13T14:33:18Z