topic Re: How to restrict values to 2 decimal points without rounding it off? in QlikView https://community.qlik.com/t5/QlikView/How-to-restrict-values-to-2-decimal-points-without-rounding-it/m-p/48737#M8081 <HTML><HEAD></HEAD><BODY><P>Would you be able to share a sample where you have this problem?</P></BODY></HTML> Mon, 04 Jun 2018 14:50:21 GMT sunny_talwar 2018-06-04T14:50:21Z How to restrict values to 2 decimal points without rounding it off? https://community.qlik.com/t5/QlikView/How-to-restrict-values-to-2-decimal-points-without-rounding-it/m-p/48736#M8080 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I need to restrict the values on a table upto 2 decimal points with rounding off the values.</P><P></P><P>Ex: if value = 0.556, I need the value as 0.55 and not 0.56.</P><P></P><P>I tried using the Floor(value, 0.01) function and Left(Value,4), But these functions doesn't give the desired output. </P><P></P><P>- Am also suppressing the null values that is one of the reasons am facing issue.</P><P></P><P>Can anyone please help me out here?</P><P></P><P>Thanks</P></BODY></HTML> Mon, 04 Jun 2018 09:22:27 GMT https://community.qlik.com/t5/QlikView/How-to-restrict-values-to-2-decimal-points-without-rounding-it/m-p/48736#M8080 Anonymous 2018-06-04T09:22:27Z Re: How to restrict values to 2 decimal points without rounding it off? https://community.qlik.com/t5/QlikView/How-to-restrict-values-to-2-decimal-points-without-rounding-it/m-p/48737#M8081 <HTML><HEAD></HEAD><BODY><P>Would you be able to share a sample where you have this problem?</P></BODY></HTML> Mon, 04 Jun 2018 14:50:21 GMT https://community.qlik.com/t5/QlikView/How-to-restrict-values-to-2-decimal-points-without-rounding-it/m-p/48737#M8081 sunny_talwar 2018-06-04T14:50:21Z Re: How to restrict values to 2 decimal points without rounding it off? https://community.qlik.com/t5/QlikView/How-to-restrict-values-to-2-decimal-points-without-rounding-it/m-p/48738#M8082 <HTML><HEAD></HEAD><BODY><P>Floor() will helps you. Can you share image?</P></BODY></HTML> Mon, 04 Jun 2018 15:25:55 GMT https://community.qlik.com/t5/QlikView/How-to-restrict-values-to-2-decimal-points-without-rounding-it/m-p/48738#M8082 Anil_Babu_Samineni 2018-06-04T15:25:55Z Re: How to restrict values to 2 decimal points without rounding it off? https://community.qlik.com/t5/QlikView/How-to-restrict-values-to-2-decimal-points-without-rounding-it/m-p/48739#M8083 <HTML><HEAD></HEAD><BODY><P>Hi!!</P><P>Try using this</P><P>num(expression,'#,##.##');</P><P>or</P><P>num(expression,'#,##.00');</P></BODY></HTML> Tue, 05 Jun 2018 04:33:49 GMT https://community.qlik.com/t5/QlikView/How-to-restrict-values-to-2-decimal-points-without-rounding-it/m-p/48739#M8083 jothimala 2018-06-05T04:33:49Z Re: How to restrict values to 2 decimal points without rounding it off? https://community.qlik.com/t5/QlikView/How-to-restrict-values-to-2-decimal-points-without-rounding-it/m-p/48740#M8084 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P></P><P>floor(0.556, 0.01) gives 0.55</P><P>what's wrong for you ?</P><P></P><P>regards</P></BODY></HTML> Tue, 05 Jun 2018 10:23:07 GMT https://community.qlik.com/t5/QlikView/How-to-restrict-values-to-2-decimal-points-without-rounding-it/m-p/48740#M8084 ogautier62 2018-06-05T10:23:07Z