Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Alteryx Designer Desktop Discussions

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

Commas on numbers with decimals

Newb27
5 - Atom

Hi, 

 

I have set of columns with numbers which have 3 decimal places.

ex: 26440843.000

10000.000

500000.000

 

how can I add commas (,) as separator for those examples? I want the result to be:

26,440,843.000

10,000.000

500,000.00

 

Appreciate your help.

2 REPLIES 2
mpennington
11 - Bolide

I think this should work: 

 

ToString(ToNumber('500000.000'),3, ',')

 

number fix.jpg

atcodedog05
22 - Nova
22 - Nova

Hi @Newb27 

 

Important note on this once you add commas value will no longer be numeric instead it will be a string.

 

Hope this helps : )

 

 

Labels