Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Formula Tool

anupgupta12
8 - Asteroid

Hi There!

 

Which formula will work to add thousand separator to numbers?

 

100000 

 

Need:-

 

100,000

5 REPLIES 5
atcodedog05
22 - Nova
22 - Nova

Hi @anupgupta12 

 

In newer version of Alteryx thousand seperator is visible. 

In older version adding a thousand seperator will convert number to string. Hence needs to be used carefully.

shreyanshrathod
11 - Bolide

Hi @anupgupta12 ,

 

At the bottom of the SELECT tool, check this option

 

shreyanshrathod_0-1621085208444.png

 

Regards,

Shreyansh Rathod

atcodedog05
22 - Nova
22 - Nova

Hi @anupgupta12 

 

You can use formula like below to add thousand separator 

IIF(Length([Amt])>3, 
REGEX_Replace([Amt], "(.*)(\d{3})", "$1,$2"), 
[Amt])

 I am checking whether length is greater than 3 (i,e greater than 999) if yes add separator after right 3 digits if not keep as same.

 

atcodedog05_0-1621085225063.png

 

Hope this helps 🙂

atcodedog05
22 - Nova
22 - Nova

Hi @shreyanshrathod 

 

Which version are you using. Is it 2021.1 or older ?

 

Because i dont remember from which version it was added 😅

shreyanshrathod
11 - Bolide

@atcodedog05 , currently using 2020.4

Labels