Free Trial

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
Top Solution Authors