topic Number format in QlikView https://community.qlik.com/t5/QlikView/Number-format/m-p/339380#M125214 <HTML><HEAD></HEAD><BODY><P>Hi </P><P>I am using the follwing formula to format a nr :</P><P>=num(sum(SALESPRICE),'$#,##0')..it returns for example 2,354,874</P><P>How can I get rid of the hudreds&nbsp; and round it as well. so it returns 2,354..</P><P>Thxs</P></BODY></HTML> Thu, 05 Apr 2012 14:22:39 GMT 2012-04-05T14:22:39Z Number format https://community.qlik.com/t5/QlikView/Number-format/m-p/339380#M125214 <HTML><HEAD></HEAD><BODY><P>Hi </P><P>I am using the follwing formula to format a nr :</P><P>=num(sum(SALESPRICE),'$#,##0')..it returns for example 2,354,874</P><P>How can I get rid of the hudreds&nbsp; and round it as well. so it returns 2,354..</P><P>Thxs</P></BODY></HTML> Thu, 05 Apr 2012 14:22:39 GMT https://community.qlik.com/t5/QlikView/Number-format/m-p/339380#M125214 2012-04-05T14:22:39Z Number format https://community.qlik.com/t5/QlikView/Number-format/m-p/339381#M125215 <HTML><HEAD></HEAD><BODY><P></P><P></P>=num(round(sum(SALESPRICE)/1000),'$#,##0')&nbsp;&nbsp;&nbsp;&nbsp; would return 2,355<P></P><P></P><P>=num(floor(sum(SALESPRICE)/1000),'$#,##0')&nbsp;&nbsp;&nbsp;&nbsp; would return 2,354</P></BODY></HTML> Thu, 05 Apr 2012 14:31:51 GMT https://community.qlik.com/t5/QlikView/Number-format/m-p/339381#M125215 m_woolf 2012-04-05T14:31:51Z