Numeric conversion

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

Output

Accepted answers

All comments

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 ","

unknown

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

unknown

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

binu_acs

@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

unknown

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

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15878

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703