Cast to string results incorrect

1229 0
Showing results for 
Search instead for 
Did you mean: 

I just burned 60+ minutes trying to track down the cause of an #ERROR condition. Ultimately, I discovered it was the result of an invalid cast from a number to a string.


  1. Field {Value} = 5.60
  2. MOD(Value,1) = 0.60
  3. MOD(Value,1)&'' = '0.5999999999999996'

Here’s a quick demo base to show the error.

Obviously, I can work around the issue by inserting a ROUND() function in my formula — but I shouldn’t have to. :winking_face:


0 Replies 0