Important Community update: The process for changing your account details was updated on June 25th. Learn how this impacts your Community experience and the actions we suggest you take to secure your account here.

Alteryx Designer Desktop Discussions

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

RegEx - amount format

tina_bencik
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
20 - Arcturus

@tina_bencik use the toSTring() function

image.png

Deano478
12 - Quasar

@tina_bencik 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     

tina_bencik
5 - Atom

Hi, yes this worked, thank you! :)

Labels