Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Alteryx is here to help you solve your biggest data challenges. Read about the new Virtual Solution Center here.

Insert Thousand Separator with Formula tool

8 - Asteroid

Hi everyone,


I'm trying to add a thousand separator in the formula tool where my exchange rate calculation is.  Is this possible?



9 - Comet

Hi jboschee,


I dont think this is available if you want to keep the field as a number - however if you are OK with changing the field to a string, you can use the ToString() function


TOSTRING(x, numDec, addCommas)Converts a numeric parameter to a string using [numDec] decimal places. There is also a third parameter to return the appropriate comma.

Optional Parameters:

addCommas: 0 or false (default) means format the numeric string without commas; 1 or true means format with commas.


TOSTRING(10, 0) returns "10" as a text string

TOSTRING(10.2, 2)returns "10.20" as a text string

TOSTRING(1000.2, 2, 1)returns "1,000.20" as a text string

8 - Asteroid

Thanks Hugo!  That worked great.