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

Insert Thousand Separator with Formula tool

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

 

Thanks!

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.

Example

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

Highlighted
8 - Asteroid

Thanks Hugo!  That worked great.

Labels