topic Formatting a large number value in a text box in QlikView https://community.qlik.com/t5/QlikView/Formatting-a-large-number-value-in-a-text-box/m-p/736402#M263449 <HTML><HEAD></HEAD><BODY><P>Hello my QV friends.&nbsp; I thought this would be easy, but so far it has not been.&nbsp; I have a text box on my report that has a number that I want formatted with commas.&nbsp; The code is simply =Sum(Units)</P><P></P><P>How do I get this to format with commas?&nbsp; I'm thinking something with Num#(), but cannot get it to work.&nbsp; Thanks.</P><P></P><P><IMG alt="Large Number.PNG.png" class="jive-image" src="/legacyfs/online/61097_Large Number.PNG.png" /></P></BODY></HTML> Tue, 24 Jun 2014 14:45:22 GMT Anonymous 2014-06-24T14:45:22Z Formatting a large number value in a text box https://community.qlik.com/t5/QlikView/Formatting-a-large-number-value-in-a-text-box/m-p/736402#M263449 <HTML><HEAD></HEAD><BODY><P>Hello my QV friends.&nbsp; I thought this would be easy, but so far it has not been.&nbsp; I have a text box on my report that has a number that I want formatted with commas.&nbsp; The code is simply =Sum(Units)</P><P></P><P>How do I get this to format with commas?&nbsp; I'm thinking something with Num#(), but cannot get it to work.&nbsp; Thanks.</P><P></P><P><IMG alt="Large Number.PNG.png" class="jive-image" src="/legacyfs/online/61097_Large Number.PNG.png" /></P></BODY></HTML> Tue, 24 Jun 2014 14:45:22 GMT https://community.qlik.com/t5/QlikView/Formatting-a-large-number-value-in-a-text-box/m-p/736402#M263449 Anonymous 2014-06-24T14:45:22Z Re: Formatting a large number value in a text box https://community.qlik.com/t5/QlikView/Formatting-a-large-number-value-in-a-text-box/m-p/736403#M263450 <HTML><HEAD></HEAD><BODY><P>=num(Sum(Units),'#,###,##0')</P></BODY></HTML> Tue, 24 Jun 2014 14:46:32 GMT https://community.qlik.com/t5/QlikView/Formatting-a-large-number-value-in-a-text-box/m-p/736403#M263450 m_woolf 2014-06-24T14:46:32Z Re: Formatting a large number value in a text box https://community.qlik.com/t5/QlikView/Formatting-a-large-number-value-in-a-text-box/m-p/736404#M263451 <HTML><HEAD></HEAD><BODY><P>Thank you Michael <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Tue, 24 Jun 2014 14:47:38 GMT https://community.qlik.com/t5/QlikView/Formatting-a-large-number-value-in-a-text-box/m-p/736404#M263451 Anonymous 2014-06-24T14:47:38Z