topic Round 9.99 to be 9 in script in QlikView

topic Round 9.99 to be 9 in script in QlikView https://community.qlik.com/t5/QlikView/Round-9-99-to-be-9-in-script/m-p/406449#M151205 <HTML><HEAD></HEAD><BODY><P>Hi guys,</P><P>Is there any way I can round all values to get red of decimals and keep the same nr.</P><P>Thxs,</P></BODY></HTML> Thu, 13 Sep 2012 20:54:22 GMT alec1982 2012-09-13T20:54:22Z Round 9.99 to be 9 in script https://community.qlik.com/t5/QlikView/Round-9-99-to-be-9-in-script/m-p/406449#M151205 <HTML><HEAD></HEAD><BODY><P>Hi guys,</P><P>Is there any way I can round all values to get red of decimals and keep the same nr.</P><P>Thxs,</P></BODY></HTML> Thu, 13 Sep 2012 20:54:22 GMT https://community.qlik.com/t5/QlikView/Round-9-99-to-be-9-in-script/m-p/406449#M151205 alec1982 2012-09-13T20:54:22Z Re: Round 9.99 to be 9 in script https://community.qlik.com/t5/QlikView/Round-9-99-to-be-9-in-script/m-p/406450#M151206 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>     Try like this</P><P></P><P>     Floor(Fieldname)</P></BODY></HTML> Thu, 13 Sep 2012 20:59:04 GMT https://community.qlik.com/t5/QlikView/Round-9-99-to-be-9-in-script/m-p/406450#M151206 MayilVahanan 2012-09-13T20:59:04Z Re: Round 9.99 to be 9 in script https://community.qlik.com/t5/QlikView/Round-9-99-to-be-9-in-script/m-p/406451#M151207 <HTML><HEAD></HEAD><BODY><P>Thxs,</P></BODY></HTML> Thu, 13 Sep 2012 21:21:08 GMT https://community.qlik.com/t5/QlikView/Round-9-99-to-be-9-in-script/m-p/406451#M151207 alec1982 2012-09-13T21:21:08Z