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
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 🙂
Which version are you using. Is it 2021.1 or older ?
Because i dont remember from which version it was added 😅
@atcodedog05 , currently using 2020.4