I have a query that calculates discount prices using the expression below:
= list price * (1-discount)
If the list price is 14.43 & the discount is .27 the query is returning $10.54. I changed the format of the field to General Number & and it returned 10.5360898451507. The the same calculation in Excel or on a calculator returns 10.5339. Why is this happening?