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!
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:
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
You could use this code instead:
if
right([_CurrentField_],1)='-'
then
'-' + replace([_CurrentField_],',','')
else
replace([_CurrentField_],',','')
endif