Good Morning,
I have a query that calculates the insurance on the sum of an invoice.
I have two invoices - the first one consisted of 3 items totalling $75.00 (30+30+15); the second one was 1 item totalling $75.00. The insurance is 17.1%.
For the first invoice the calculation returned a total of $10.26 which is 17.1% of $60. For the second one the calculation returned a total of $12.83 which is correct. Any idea why the first invoice would return an incorrect total?
I have a query that calculates the insurance on the sum of an invoice.
I have two invoices - the first one consisted of 3 items totalling $75.00 (30+30+15); the second one was 1 item totalling $75.00. The insurance is 17.1%.
For the first invoice the calculation returned a total of $10.26 which is 17.1% of $60. For the second one the calculation returned a total of $12.83 which is correct. Any idea why the first invoice would return an incorrect total?