Numeric conversion
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
- Labels:
- Output
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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 ","
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @AngelosPachis - Am looking for simple formula to process the data sets. Is there any way ? please advice.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@Inactive User If you change to 1.000,00 you should change the datatype to string
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Try this formula:
ToString([Field1], 2, 1,",")
But you will need to create a string field to do this
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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