Multiple Discounts using new totals
I have a table to hold all discounts. I am trying to find a way to run a calculation that runs each discount and re-totals and runs the next until all discounts are complete. I know this could be accomplished via script but I would like to avoid breaking normalization on such an important number (the final price!!!).
total before discount $100.00
15% off $85.00
10% off $76.50
This puts the total discount @ 23.5% not the 25% you would get by summing the discounts and then dividing.
Thank you in advance,