How do I convert a number to currency with comma and no decimals? For example, I would like 23600.3264 to appear as $23,600 in my summaries and pivot tables. Thanks!
Use the formula in a string field:
"$"+tostring([Field],0,1)
Keep in mind that once you add the "$" and "," character, this must be a string field. The arguments for the tostring( function are <Field>,<Decimal Places>,<Binary flag to add thousands commas>
worked perfectly - thanks!
I tried to do this its not working for me
Thanks @CharlieS It was a great explanation.
