query's aggregate sum amount is off by $.01
Hello, I created a query but I find that the aggregate sum of the amount is off by $.01.
See screenshots:
If you add up the five amounts above, the sum is $5364.52
The field is an expression:
But if I update the aggregate to 'Sum' and run the query again, the sum is off by $.01
How do I make the query sum match the actual sum? Thanks for your help.