Hi
Am trying to bring in thousand separator using below, not sure what is wrong, have experimented with a few different data types. Any advice? thanks
You need to attach the spreadsheet otherwise the module doesn't work. But I can see what's happening, I think.
ToString must result in a "string" field. You must have a "numeric" field going into the formula tool. You can't update a numeric field to a string field with a formula tool.
So . . . create a new field with the formula tool, say "Sales_String", and then it will work.
Hi @BillyL14,
according to this topic:
https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Insert-Thousand-Separator-with-Formula-tool/m-p/122469/highlight/true#M35929
you need to use this formula:
TOSTRING(1000.2, 2, 1)returns "1,000.20" as a text string
in order to make it work for your example we need to put a column name:
TOSTRING([sales], 2, 1)
Hi @BillyL14 ,
Your formula is fine, but it only works for NUMERIC fields. Your 138038 as you show in your screen shot is a STRING field. If it were a numeric field, then your formula would work.
Hi @mbarone
I actually have tried a numeric field but doesn't seem to work for me
Have attached my workflow in case my problem is coming from somewhere upstream? Bit confused
Thanks
@Emil_Kos thanks
