topic Re: Round Division to Two Decimal Places in QlikView https://community.qlik.com/t5/QlikView/Round-Division-to-Two-Decimal-Places/m-p/1057563#M354332 <HTML><HEAD></HEAD><BODY><P>If you want to round then use the round() function: Round(Count(x)/Count(y), 0.01)</P><P>Other options are the floor() and ceil() function. The num() function will not round the value, but only change the display format.</P></BODY></HTML> Fri, 11 Mar 2016 17:21:20 GMT Gysbert_Wassenaar 2016-03-11T17:21:20Z Round Division to Two Decimal Places https://community.qlik.com/t5/QlikView/Round-Division-to-Two-Decimal-Places/m-p/1057561#M354330 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>&nbsp;&nbsp; I have an expression something like <SPAN style="color: #ff6600;">count(x)/count(y)&nbsp; </SPAN>the results are sometimes many decimal places <SPAN style="color: #ff6600;">Ex. 1234/3.9 = 316.410256410256</SPAN>. Can you give me an example of the syntax to limit it to two decimal places?</P><P></P><P>Thanks</P></BODY></HTML> Fri, 11 Mar 2016 16:32:04 GMT https://community.qlik.com/t5/QlikView/Round-Division-to-Two-Decimal-Places/m-p/1057561#M354330 2016-03-11T16:32:04Z Re: Round Division to Two Decimal Places https://community.qlik.com/t5/QlikView/Round-Division-to-Two-Decimal-Places/m-p/1057562#M354331 <HTML><HEAD></HEAD><BODY><P>May be this:</P><P></P><P><STRONG>Num(Count(x)/Count(y), '##.00')</STRONG></P></BODY></HTML> Fri, 11 Mar 2016 17:15:28 GMT https://community.qlik.com/t5/QlikView/Round-Division-to-Two-Decimal-Places/m-p/1057562#M354331 sunny_talwar 2016-03-11T17:15:28Z Re: Round Division to Two Decimal Places https://community.qlik.com/t5/QlikView/Round-Division-to-Two-Decimal-Places/m-p/1057563#M354332 <HTML><HEAD></HEAD><BODY><P>If you want to round then use the round() function: Round(Count(x)/Count(y), 0.01)</P><P>Other options are the floor() and ceil() function. The num() function will not round the value, but only change the display format.</P></BODY></HTML> Fri, 11 Mar 2016 17:21:20 GMT https://community.qlik.com/t5/QlikView/Round-Division-to-Two-Decimal-Places/m-p/1057563#M354332 Gysbert_Wassenaar 2016-03-11T17:21:20Z Re: Round Division to Two Decimal Places https://community.qlik.com/t5/QlikView/Round-Division-to-Two-Decimal-Places/m-p/1057564#M354333 <HTML><HEAD></HEAD><BODY><P>Thank you for answering this.</P></BODY></HTML> Fri, 11 Mar 2016 19:42:44 GMT https://community.qlik.com/t5/QlikView/Round-Division-to-Two-Decimal-Places/m-p/1057564#M354333 2016-03-11T19:42:44Z Re: Round Division to Two Decimal Places https://community.qlik.com/t5/QlikView/Round-Division-to-Two-Decimal-Places/m-p/1057565#M354334 <HTML><HEAD></HEAD><BODY><P>Thanks for answering this.</P></BODY></HTML> Fri, 11 Mar 2016 19:44:32 GMT https://community.qlik.com/t5/QlikView/Round-Division-to-Two-Decimal-Places/m-p/1057565#M354334 2016-03-11T19:44:32Z