Text Object Number Formating

[Anonymous]

I am trying to format the following expression:

=Count(Distinct [Script Number] ) whose value is 26186 to be 26,186 and i am getting errors.  How can i accomplish this.

Thanks in advance.

[JonnyPoole · Accepted solution]

Does this work ? 

num( Count(Distinct [Script Number] ), '#,###')

or

num( Count(Distinct [Script Number] ), '#,##0')

[Anonymous]

Many thanks, the trick was on the "Num"

Regards.