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?
Solved! Go to Solution.
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
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.
Easiest Solution-
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
Really appreciate your help, thanks!
Thank you so much for this!
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!
yup! absolutely, thanks for your response!