Cast to string results incorrect

[W_Vann_Hall]

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

Thanks!