AnsweredAssumed Answered

Multiple Discounts using new totals

Question asked by on Jul 28, 2010
Latest reply on Jul 28, 2010 by


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,