Cast to string results incorrect


#1

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.

Situation:

  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. :wink:

Thanks!