The subtract function seems to be incorrect during preview

While previewing this, the subtract function does not show the correct difference. I ended up using the compare functionality instead and got the results I expected. I will also note that these fields are money in MS-SQL. The Int didn't have this issue.




Here's a video explaining the scenario: screencast-o-matic.com/watch/c0nnrPVxxV9

This is normal behaviour for float data types

We will check it internally

I have the issue resolved using the compare functionality. That works great. I might look at another field type for other reasons.