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 12345 to $12,345.00 in alteryx

Highlighted
6 - Meteoroid

Hi All,

 

I am trying to convert a 12345 into $12,345.00 in alteryx but i am unable to

 

i tried to use the  ToString Formula but i am unable to get the commas

 

Can anyone please help?

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

Hi @rinair ,

 

Your function and parameter are configured as it should. The only thing you need to change is your [Value] format, it needs to be a number format in order to work.

 

Best,

Fernando Vizcaino

Highlighted
Alteryx Partner

Hi @rinair , the select tool you are using has configured datatype for the column value as V_String, try changing to double ,int64 or any other number datatype and then check if the things workout for you?

Thanks.

grazitti_sapna_0-1592197536993.png

 

Highlighted
7 - Meteor

Easiest Solution-

aman_goyal_0-1592197587933.png

 

Highlighted
Alteryx Certified Partner

Hi @rinair ,

 

Please consider marking the answer from @aman_goyal as an accepted solution as to help others find it as well. Besides his solution, there's a great resource on the Alteryx Designer Help page that answers your question as well.

 

The page: https://help.alteryx.com/2019.3/Reference/Functions.htm

tostring.jpg

 

Best,
 
Roland
 
Infotopics - Benelux partner of the year
Empowering business through analytics. See, Understand, Act!
Highlighted
6 - Meteoroid

Really appreciate your help, thanks!

Highlighted
6 - Meteoroid

Thank you so much for this!

Highlighted
6 - Meteoroid

hey, thanks for taking time out to help me, i did try your solution, but using Int16 was removing the decimal point which was not serving the purpose, i have to continue with a float or double but thanks for helping!

Highlighted
6 - Meteoroid

yup! absolutely, thanks for your response!

Labels