AnsweredAssumed Answered

Multiple Discounts using new totals

Question asked by cstowell@crown-point.com on Jul 28, 2010
Latest reply on Jul 28, 2010 by cstowell@crown-point.com

Title

Multiple Discounts using new totals

Post

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!!!).

Example:

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,

Craig

Outcomes