Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Don't forget to submit your entry for the Excellence Awards by October 30! | Need more information about the program? Check out the blog here
SOLVED

Convert Format to $

Highlighted
5 - 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!

Highlighted
Alteryx Certified Partner
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>

Highlighted
5 - Atom

worked perfectly - thanks!

Highlighted
5 - Atom

Do you know, is there a similar function if the data is numeric? I'm hoping for excel type number formatting that will allow formulas to be written on the data.

Highlighted
6 - Meteoroid

I tried to do this its not working for me

Highlighted
8 - Asteroid

try to create a new column and add the formula. Updating the same one might not work.

Labels