Cast to string results incorrect

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!

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.