topic Re: Qlik: Rounding Errors in QlikView https://community.qlik.com/t5/QlikView/Qlik-Rounding-Errors/m-p/774984#M1032363 <HTML><HEAD></HEAD><BODY><P>Great ! That worked perfectly</P></BODY></HTML> Tue, 27 Jan 2015 17:18:52 GMT 2015-01-27T17:18:52Z Qlik: Rounding Errors https://community.qlik.com/t5/QlikView/Qlik-Rounding-Errors/m-p/774982#M1032360 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have a scenario where I am displaying percentages from a source column eg.:</P><P><IMG __jive_id="76395" alt="27-01-2015 16-17-35.jpg" class="image-1 jive-image" src="/legacyfs/online/76395_27-01-2015 16-17-35.jpg" style="height: auto;" /></P><P>The values are just getting rounded off as I want to show the number as a percentage with 2 decimal places. I have been using the following syntax but it does not help:</P><P></P><P>Num(Source Value, ####.##)</P><P></P><P>What I am really looking for is the equivalent of a TRUNC function in Informatica where you could simply truncate upto 'n' decimal places. I am not sure if Ceil or Floor would help either. Please suggest</P></BODY></HTML> Tue, 27 Jan 2015 16:21:50 GMT https://community.qlik.com/t5/QlikView/Qlik-Rounding-Errors/m-p/774982#M1032360 2015-01-27T16:21:50Z Re: Qlik: Rounding Errors https://community.qlik.com/t5/QlikView/Qlik-Rounding-Errors/m-p/774983#M1032361 <HTML><HEAD></HEAD><BODY><P>The floor function would be best for you, if you want it to 2 d.p. use Floor([Source Value], 0.0001) and then show in percentage at 2 d.p., and it should give you what you want.</P></BODY></HTML> Tue, 27 Jan 2015 16:32:59 GMT https://community.qlik.com/t5/QlikView/Qlik-Rounding-Errors/m-p/774983#M1032361 morganaaron 2015-01-27T16:32:59Z Re: Qlik: Rounding Errors https://community.qlik.com/t5/QlikView/Qlik-Rounding-Errors/m-p/774984#M1032363 <HTML><HEAD></HEAD><BODY><P>Great ! That worked perfectly</P></BODY></HTML> Tue, 27 Jan 2015 17:18:52 GMT https://community.qlik.com/t5/QlikView/Qlik-Rounding-Errors/m-p/774984#M1032363 2015-01-27T17:18:52Z