Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Convert Format to $

bc4
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!

6 REPLIES 6
CharlieS
17 - Castor
17 - Castor

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>

bc4
5 - Atom

worked perfectly - thanks!

swillson
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.

rinair
6 - Meteoroid

I tried to do this its not working for me

vepp
8 - Asteroid

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

suyashkashyap
6 - Meteoroid

Thanks @CharlieS  It was a great explanation. 

Labels