Alteryx Designer Desktop Discussions

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

convert 12345 to $12,345.00 in alteryx

rinair
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?

8 REPLIES 8
fmvizcaino
17 - Castor
17 - Castor

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

grazitti_sapna
17 - Castor

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

 

Sapna Gupta
aman_goyal
8 - Asteroid

Easiest Solution-

aman_goyal_0-1592197587933.png

 

RWvanLeeuwen
11 - Bolide

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!
rinair
6 - Meteoroid

Really appreciate your help, thanks!

rinair
6 - Meteoroid

Thank you so much for this!

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

rinair
6 - Meteoroid

yup! absolutely, thanks for your response!

Labels