Numeric conversion

[Inactive User]

Hi Experts,

Have a large datasets,below is one of the example which i need to convert the numeric value as an output. The data type is mentioned as "Decimal" on select tool.

1000.00 to be converted to 1.000,00 

100000.00 to be converted to 100.000,00

Please advice.

Thanks,

Guru

[dougperez]

Hello @Inactive User !

Here in Brazil we use comma as decimal separators, try to convert these fields into a string field and then just replace the "." for ","

[Inactive User]

Hello @dougperez 

If i change the sting - it will only replaces the decimal as comma, but however is it will not change the numeric.
Example -  currently alteryx is reading as only 1000.00 i.e.1,000.00, but i need to make it 1.000,00. 
Thanks,
Guru 

[AngelosPachis]

Hi @Inactive User ,

Maybe you can check your user settings? There you can define what's your thousand separator is and what's your decimal separator

[Inactive User]

Hi @AngelosPachis - Am looking for simple formula to process the data sets. Is there any way ? please advice. 

[binuacs]

@Inactive User If you change to 1.000,00 you should change the datatype to string

[dougperez]

Try this formula:

ToString([Field1], 2, 1,",")

But you will need to create a string field to do this

[Inactive User]

Hi @dougperez - I tried this logic, it will only help me to perform only on the decimal part. 
Here i need to change a large data set involving multiple values involving thousands, millions as amounts. 
Example - 10234.13 needs to change 10.234,13
                  10012345.19 needs to change to  10.012.345,19

can you please help me ?

Thanks,
Guru