I have 6 records with the following values. -732.05, 18.67, 82.9, 138.16, 138.16 and 354.16. When I Total the field the result should b 0 but actually is -5.6843418860808e-14. The field is set to numeric, float in the design sheet. Thoughts?
This is the result of your floating point numbers: a very, very small number extremely close to 0.
Set your field up with an output pattern (e.g. 2 decimals), and it will give you "0.00".
Thank you. That worked.