topic Need Decimal in QlikView https://community.qlik.com/t5/QlikView/Need-Decimal/m-p/314882#M116159 <HTML><HEAD></HEAD><BODY><P>=Sum(num_leads)&nbsp; / Sum(num_users).&nbsp; I have this expression.&nbsp; Right now it returns 1 but I need it to be 1.25 and can't get it to show me the decimal value.&nbsp; </P><P></P><P>Any suggestions?</P></BODY></HTML> Fri, 27 Jan 2012 23:33:16 GMT 2012-01-27T23:33:16Z Need Decimal https://community.qlik.com/t5/QlikView/Need-Decimal/m-p/314882#M116159 <HTML><HEAD></HEAD><BODY><P>=Sum(num_leads)&nbsp; / Sum(num_users).&nbsp; I have this expression.&nbsp; Right now it returns 1 but I need it to be 1.25 and can't get it to show me the decimal value.&nbsp; </P><P></P><P>Any suggestions?</P></BODY></HTML> Fri, 27 Jan 2012 23:33:16 GMT https://community.qlik.com/t5/QlikView/Need-Decimal/m-p/314882#M116159 2012-01-27T23:33:16Z Need Decimal https://community.qlik.com/t5/QlikView/Need-Decimal/m-p/314883#M116160 <HTML><HEAD></HEAD><BODY><P>In properties,there is a sheet "number". You can set 2 decimal here.</P></BODY></HTML> Sat, 28 Jan 2012 03:18:50 GMT https://community.qlik.com/t5/QlikView/Need-Decimal/m-p/314883#M116160 2012-01-28T03:18:50Z Need Decimal https://community.qlik.com/t5/QlikView/Need-Decimal/m-p/314884#M116161 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>You can use this : NUM(Sum(num_leads)&nbsp; / Sum(num_users),'0.00')</P><P></P><P>Regards,</P><P>Sokkorn Cheav</P></BODY></HTML> Sat, 28 Jan 2012 04:34:04 GMT https://community.qlik.com/t5/QlikView/Need-Decimal/m-p/314884#M116161 Sokkorn 2012-01-28T04:34:04Z Need Decimal https://community.qlik.com/t5/QlikView/Need-Decimal/m-p/314885#M116162 <HTML><HEAD></HEAD><BODY><P> num(Sum(num_leads)&nbsp; / Sum(num_users),'#0,00')</P></BODY></HTML> Sat, 28 Jan 2012 09:24:17 GMT https://community.qlik.com/t5/QlikView/Need-Decimal/m-p/314885#M116162 2012-01-28T09:24:17Z