Hi There!
Which formula will work to add thousand separator to numbers?
100000
Need:-
100,000
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.
Hi @anupgupta12 ,
At the bottom of the SELECT tool, check this option
Regards,
Shreyansh Rathod
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 🙂
Hi @shreyanshrathod
Which version are you using. Is it 2021.1 or older ?
Because i dont remember from which version it was added 😅
