topic Re: formatting numbers in QlikView https://community.qlik.com/t5/QlikView/formatting-numbers/m-p/824705#M290485 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Try Floor(FieldName,0.01)</P></BODY></HTML> Tue, 31 Mar 2015 07:27:53 GMT PrashantSangle 2015-03-31T07:27:53Z formatting numbers https://community.qlik.com/t5/QlikView/formatting-numbers/m-p/824704#M290484 <HTML><HEAD></HEAD><BODY><P>Hello </P><P>got values on a pivot table that are like:</P><P>1.498</P><P>1.491</P><P></P><P>what I want is display 2 decimal places but without rounding</P><P>I'm using the following format #,##.00</P><P>and I get for the above values 1.50</P><P>what I want is 1.49</P><P></P><P>is this possible?</P></BODY></HTML> Tue, 31 Mar 2015 07:22:20 GMT https://community.qlik.com/t5/QlikView/formatting-numbers/m-p/824704#M290484 ali_hijazi 2015-03-31T07:22:20Z Re: formatting numbers https://community.qlik.com/t5/QlikView/formatting-numbers/m-p/824705#M290485 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Try Floor(FieldName,0.01)</P></BODY></HTML> Tue, 31 Mar 2015 07:27:53 GMT https://community.qlik.com/t5/QlikView/formatting-numbers/m-p/824705#M290485 PrashantSangle 2015-03-31T07:27:53Z Re: formatting numbers https://community.qlik.com/t5/QlikView/formatting-numbers/m-p/824706#M290486 <HTML><HEAD></HEAD><BODY><P>Try this format:</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">#,##0.00</SPAN></P></BODY></HTML> Tue, 31 Mar 2015 07:29:51 GMT https://community.qlik.com/t5/QlikView/formatting-numbers/m-p/824706#M290486 fvelascog72 2015-03-31T07:29:51Z Re: formatting numbers https://community.qlik.com/t5/QlikView/formatting-numbers/m-p/824707#M290487 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>You can try this format.</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">#,##.##</SPAN></P></BODY></HTML> Tue, 31 Mar 2015 08:01:27 GMT https://community.qlik.com/t5/QlikView/formatting-numbers/m-p/824707#M290487 2015-03-31T08:01:27Z Re: formatting numbers https://community.qlik.com/t5/QlikView/formatting-numbers/m-p/824708#M290488 <HTML><HEAD></HEAD><BODY><P>You need to use a rounding function in you expression.</P><P></P><P><STRONG>Round(number, precision)</STRONG> rounds the number up or down.</P><P><STRONG>Floor(number, precision)</STRONG> rounds down</P><P><STRONG>Ceil(number, precision)</STRONG> rounds up</P><P></P><P>The expression your need to use is <STRONG>Floor(YourValue, 0.01)</STRONG></P></BODY></HTML> Tue, 31 Mar 2015 08:07:12 GMT https://community.qlik.com/t5/QlikView/formatting-numbers/m-p/824708#M290488 Colin-Albert 2015-03-31T08:07:12Z