This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I have a data field [Field1] formated as double and it contains entries in European/German digit format such as 4.000 (four thousend: 4000) and 32.000,89 (thirty-two thousend dot eighty-nine: 32000.98).
How can I get rid of the dot as thousands separator?
I have tried ToString([Field1], 2) in order to replace the dot in a next sept,but it turns 4.000 into 4.00, which means 4000 into 4.
If you have numbers that contain both . period as thousands separator and , comma as decimal indicator, you'll likely need to handle a bit differently.
Try the following formula, followed by a select field to change your data type to Double.
This will first remove the period as the thousands separator, and then change any commas as decimal indicators to periods.
Note that Alteryx does not format numbers with thousand separators while using numeric data types in your workflow, so if you are doing anything in Alteryx with these values after their conversion, you'll need to leave a thousands separator out of the result, i.e. (4000 and 32000.89 rather than 4,000 and 32,000.89).