topic Re: Round function in QlikView https://community.qlik.com/t5/QlikView/Round-function/m-p/1294186#M404209 <HTML><HEAD></HEAD><BODY><P>ROUND(x*100, 1)</P></BODY></HTML> Thu, 18 May 2017 13:19:19 GMT prieper 2017-05-18T13:19:19Z Round function https://community.qlik.com/t5/QlikView/Round-function/m-p/1294184#M404207 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>How can I convert 0.7677 to 77 ?</P><P></P><P>I used round(0.7677,0.05)* 100 but it gives 75.</P><P></P><P>Please help.</P><P></P><P>Thanks</P></BODY></HTML> Thu, 18 May 2017 13:12:36 GMT https://community.qlik.com/t5/QlikView/Round-function/m-p/1294184#M404207 qlikuser222 2017-05-18T13:12:36Z Re: Round function https://community.qlik.com/t5/QlikView/Round-function/m-p/1294185#M404208 <HTML><HEAD></HEAD><BODY><P>=round(0.7677,0.<STRONG>01</STRONG>)* 100</P></BODY></HTML> Thu, 18 May 2017 13:18:56 GMT https://community.qlik.com/t5/QlikView/Round-function/m-p/1294185#M404208 tresB 2017-05-18T13:18:56Z Re: Round function https://community.qlik.com/t5/QlikView/Round-function/m-p/1294186#M404209 <HTML><HEAD></HEAD><BODY><P>ROUND(x*100, 1)</P></BODY></HTML> Thu, 18 May 2017 13:19:19 GMT https://community.qlik.com/t5/QlikView/Round-function/m-p/1294186#M404209 prieper 2017-05-18T13:19:19Z Re: Round function https://community.qlik.com/t5/QlikView/Round-function/m-p/1294187#M404210 <HTML><HEAD></HEAD><BODY><P>May be do this?</P><P><STRONG>=Round(0.7677 * 100)</STRONG></P><P><STRONG>Or</STRONG></P><P><STRONG>=Round(Sum(Sales) * 100)</STRONG></P></BODY></HTML> Thu, 18 May 2017 13:19:20 GMT https://community.qlik.com/t5/QlikView/Round-function/m-p/1294187#M404210 Anil_Babu_Samineni 2017-05-18T13:19:20Z Re: Round function https://community.qlik.com/t5/QlikView/Round-function/m-p/1294188#M404211 <HTML><HEAD></HEAD><BODY><P>I suggest you reading:</P><P><A href="http://help.qlik.com/en-US/qlikview/12.0/Subsystems/Client/Content/ChartFunctions/GeneralNumericFunctions/round.htm" style="font-size: 10pt;" title="http://help.qlik.com/en-US/qlikview/12.0/Subsystems/Client/Content/ChartFunctions/GeneralNumericFunctions/round.htm">Round ‒ QlikView</A></P><P><A href="http://help.qlik.com/en-US/qlikview/12.0/Subsystems/Client/Content/ChartFunctions/GeneralNumericFunctions/ceil.htm" style="font-size: 13.3333px;" title="http://help.qlik.com/en-US/qlikview/12.0/Subsystems/Client/Content/ChartFunctions/GeneralNumericFunctions/ceil.htm">Ceil ‒ QlikView</A></P><P><A href="http://help.qlik.com/en-US/qlikview/12.0/Subsystems/Client/Content/ChartFunctions/GeneralNumericFunctions/floor.htm" title="http://help.qlik.com/en-US/qlikview/12.0/Subsystems/Client/Content/ChartFunctions/GeneralNumericFunctions/floor.htm">Floor ‒ QlikView</A></P><P></P><P><IMG alt="Screenshot_1.jpg" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/163922_Screenshot_1.jpg" style="height: auto;" /></P></BODY></HTML> Thu, 18 May 2017 13:54:09 GMT https://community.qlik.com/t5/QlikView/Round-function/m-p/1294188#M404211 MindaugasBacius 2017-05-18T13:54:09Z