Formula Tool

[anupgupta12]

Hi There!

Which formula will work to add thousand separator to numbers?

100000 

Need:-

100,000

[atcodedog05]

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]

Hi @anupgupta12 ,

At the bottom of the SELECT tool, check this option

Regards,

Shreyansh Rathod

[atcodedog05]

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.

Hope this helps 🙂

[atcodedog05]

Hi @shreyanshrathod 

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

Because i dont remember from which version it was added 😅

[shreyanshrathod]

@atcodedog05 , currently using 2020.4