So I have two fields from two different tables. Both are number data type. I am subtracting to verify that they match and even though they do (ex. customer has 15646.23 in table 1 and 15646.23 in table 2) the result is not 0 as expected. I get -2.215654646E03.
Anyone know why? and what can I do to avoid this and just get zero difference when numbers match?