In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

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

RegEx - amount format

Beti1234
5 - Atom

Hi, I am trying to use RegEx to format my amounts output. I have an amount example 1234.000 but I want to transform it into 1,234.000 or if the amount is 12345.000 I want it to be transformed to 12,345.000 how should I write the formula?

 

thank you!

3 REPLIES 3
binuacs
21 - Polaris

@Beti1234 use the toSTring() function

image.png

Deano478
12 - Quasar

@Beti1234 to add to @binuacs answer if you are adding in commas as value separators you wont be able to keep the value as a number it will need to be converted to string     

Beti1234
5 - Atom

Hi, yes this worked, thank you! :)

Labels
Top Solution Authors