adding commas to long numbers

[CSemrau]

I have a data field for mileage on an automobile. I need to add commas in the thousands place...Help

 

eg. 9000 needs to be 9,000

 

Thanks in advance.

[Alex Marshall]

Hello,

You can use the FormatNumber function in FusionPro to accomplish this.

Simply create a rule as in this example:

 

return FormatNumber("0,000",Field("MyNumberField"));

[CSemrau]

Thanks so much. It worked great. I had it close....just not functional!