potts
Registered User.
- Local time
- Today, 19:48
- Joined
- Jul 24, 2002
- Messages
- 87
I have a form to enter information of people training in a gym for invoiceing purposes. A number of groups receive a percentage discount. However, I need the figures rounded to the nearest penny. I thought I had it, but when the totals are calculated, the rounded value is not reflected e.g.
4 people get a discount rate of £2.00 from £4.50 and are therefore charged £2.50
As the % calculation is 44.5% discount, the real discounted value is £2.0025 instead of the desired £2.00
So the total works out as £9.99 instead of the desired £10.00
How can I fix this without changing the discount to a currency rather than a percentage?
4 people get a discount rate of £2.00 from £4.50 and are therefore charged £2.50
As the % calculation is 44.5% discount, the real discounted value is £2.0025 instead of the desired £2.00
So the total works out as £9.99 instead of the desired £10.00
How can I fix this without changing the discount to a currency rather than a percentage?