Forum Discussion
Solved
Convert to decimal
Hello,
I have a problem with converting a field to decimal. There are instances where it has one decimal and other two decimals. I tried to replace the 0.0 with 0.00 and then check for the 3 last characters where the first character is not a fullstop and then pad a zero on but it did not work. Any ideas to do this in a efficient manner?
I have done that first yes, but then it gives an error. I have however resolved the issue by replacing the fullstop (".") with a comma (",") and then convert it to decimal. Thank you.
2 Replies
I have done that first yes, but then it gives an error. I have however resolved the issue by replacing the fullstop (".") with a comma (",") and then convert it to decimal. Thank you.
