topic Problem with decimals in QlikView https://community.qlik.com/t5/QlikView/Problem-with-decimals/m-p/154218#M30920 <HTML><HEAD></HEAD><BODY><P>Thanx it worked!</P></BODY></HTML> Fri, 22 Oct 2010 14:39:33 GMT francisvandergr 2010-10-22T14:39:33Z Problem with decimals https://community.qlik.com/t5/QlikView/Problem-with-decimals/m-p/154216#M30918 <HTML><HEAD></HEAD><BODY><P>In my load statement i have the following set statement for money :</P><P>SET MoneyFormat='#.##0,00;-#.##0,00';</P><P>This works good, but now i have a text box with a formula for example:</P><P>=money(sum(48/49)) The result of this formula i want in 5 decimals. How can i do that ?</P></BODY></HTML> Fri, 22 Oct 2010 11:12:20 GMT https://community.qlik.com/t5/QlikView/Problem-with-decimals/m-p/154216#M30918 francisvandergr 2010-10-22T11:12:20Z Problem with decimals https://community.qlik.com/t5/QlikView/Problem-with-decimals/m-p/154217#M30919 <HTML><HEAD></HEAD><BODY><P>Try this</P><P>=</P><BR /><BR /> <P><B>Num</B>(<B>money</B>(<B>sum</B>(48/49)), '#.######')</P><P>Regards</P><P>Ren</P></BODY></HTML> Fri, 22 Oct 2010 11:40:33 GMT https://community.qlik.com/t5/QlikView/Problem-with-decimals/m-p/154217#M30919 renjithpl 2010-10-22T11:40:33Z Problem with decimals https://community.qlik.com/t5/QlikView/Problem-with-decimals/m-p/154218#M30920 <HTML><HEAD></HEAD><BODY><P>Thanx it worked!</P></BODY></HTML> Fri, 22 Oct 2010 14:39:33 GMT https://community.qlik.com/t5/QlikView/Problem-with-decimals/m-p/154218#M30920 francisvandergr 2010-10-22T14:39:33Z