Skip to main content

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!

Be the first to reply!

Reply