Formatting a large number value in a text box

[Anonymous]

Hello my QV friends.  I thought this would be easy, but so far it has not been.  I have a text box on my report that has a number that I want formatted with commas.  The code is simply =Sum(Units)

How do I get this to format with commas?  I'm thinking something with Num#(), but cannot get it to work.  Thanks.

[m_woolf · Accepted solution]

=num(Sum(Units),'#,###,##0')

[Anonymous]

Thank you Michael