Decimal roundind and replacing decimal with comma

[sneha_bhiwagade1]

Hi Team,

I would like to round the below values to 2 decimal places and replace . (dot) with , (comma)

sample

0.100

0.600

0.800

0.2000

Expected output as 0,1

0,6

0,8

0,2

Many thanks in advance !!

[DataNath]

Hey @sneha_bhiwagade1, if you insist on using a comma as a decimal separator, you'll need to create a string value. In a Formula tool, you can use the following expression (I have also limited it to 1 decimal place as you said 2 in your opening statement but then just show 1 in your expected output. If you do actually want 2 then just change the second argument in the function i.e. the one after [sample] to a 2):

ToString([sample], 1, 0, ',')

[ChrisTX]

For details on Rounding, check out this related post:  

https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Round-rounds-up-if-the-next-di...

Also check out Options > User Settings > Edit User Settings > tab for Localization.

 

Chris