community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Community v19.6

Looks aren't everything... But the latest Community refresh looks darn good!

Learn More
SOLVED

Convert Format to $

Atom

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!

Alteryx Certified Partner

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>

Atom

worked perfectly - thanks!

Labels