String to Double

Question

Hello, can somebody help me using the select tool. I tried to convert the string into double, but it seems that the output is changing the amount into a whole number. Is there any other way how I can convert the transaction amount into a normal number? Thanks in advance!

Capture2.PNG

Capture.PNG

FinnCharlton · Answer

You could use this code instead:

if
right([_CurrentField_],1)='-'
then
'-' + replace([_CurrentField_],',','')
else
replace([_CurrentField_],',','')
endif

Rayyyyy · Answer

Hi @Fincharlton,

thanks for your reply, however have I also tried to do that procedure but the "-" represents as a negative amount. So in that case the amount must be -589,339.70. Thanks

FinnCharlton · Answer

Hey @Rayyyyy , you can get around this by removing the comma in your number. I recommend doing it in a Multi-Field Formula tool, as you can change the data type of the field in the same tool. Copy this configuration: