topic How to make it return with out decimal point ? in QlikView https://community.qlik.com/t5/QlikView/How-to-make-it-return-with-out-decimal-point/m-p/1310608#M616313 <HTML><HEAD></HEAD><BODY><P>Hi All</P><P></P><P>I use below expression :-</P><P></P><P>money(</P><P>sum(sales/Rate)</P><P>,$#,##0)</P><P></P><P>it return with 2 decimal point.</P><P></P><P>May i know how to make it return with decimal point ?</P><P></P><P>Paul</P></BODY></HTML> Mon, 05 Jun 2017 08:20:50 GMT paulyeo11 2017-06-05T08:20:50Z How to make it return with out decimal point ? https://community.qlik.com/t5/QlikView/How-to-make-it-return-with-out-decimal-point/m-p/1310608#M616313 <HTML><HEAD></HEAD><BODY><P>Hi All</P><P></P><P>I use below expression :-</P><P></P><P>money(</P><P>sum(sales/Rate)</P><P>,$#,##0)</P><P></P><P>it return with 2 decimal point.</P><P></P><P>May i know how to make it return with decimal point ?</P><P></P><P>Paul</P></BODY></HTML> Mon, 05 Jun 2017 08:20:50 GMT https://community.qlik.com/t5/QlikView/How-to-make-it-return-with-out-decimal-point/m-p/1310608#M616313 paulyeo11 2017-06-05T08:20:50Z Re: How to make it return with out decimal point ? https://community.qlik.com/t5/QlikView/How-to-make-it-return-with-out-decimal-point/m-p/1310609#M616314 <HTML><HEAD></HEAD><BODY><P>Is this a typo? Did you put quotes around the format like?</P><P></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">money( sum(sales/Rate) ,<STRONG>'</STRONG>$#,##0<STRONG>'</STRONG>)</P></BODY></HTML> Mon, 05 Jun 2017 08:51:23 GMT https://community.qlik.com/t5/QlikView/How-to-make-it-return-with-out-decimal-point/m-p/1310609#M616314 tresB 2017-06-05T08:51:23Z Re: How to make it return with out decimal point ? https://community.qlik.com/t5/QlikView/How-to-make-it-return-with-out-decimal-point/m-p/1310610#M616315 <HTML><HEAD></HEAD><BODY><P>Try this</P><P></P><P></P><P></P><P>=money(<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">sum(sales/Rate)</SPAN>,'$#,##0','.',',')</P></BODY></HTML> Mon, 05 Jun 2017 09:06:56 GMT https://community.qlik.com/t5/QlikView/How-to-make-it-return-with-out-decimal-point/m-p/1310610#M616315 kamal_sanguri 2017-06-05T09:06:56Z Re: How to make it return with out decimal point ? https://community.qlik.com/t5/QlikView/How-to-make-it-return-with-out-decimal-point/m-p/1310611#M616316 <HTML><HEAD></HEAD><BODY><P>Hi All</P><P></P><P>Thank you very much , all work.</P><P></P><P>Paul Yeo</P></BODY></HTML> Mon, 05 Jun 2017 09:10:04 GMT https://community.qlik.com/t5/QlikView/How-to-make-it-return-with-out-decimal-point/m-p/1310611#M616316 paulyeo11 2017-06-05T09:10:04Z