Calculating Discount
Hmmm, I can't see how that'd work without a reference to the Discount Exempt field that I had set up. On rereading my entries here I may be confusing the issue regarding when the discount is applicable. 10% is applicable when they buy 6 bottles or more, 20% when they buy 12 or more ... HOWEVER, it can be a mixed purchase. If a buyer wants 3 whites, 2 reds and a port they get a 10% discount because they bought 6 bottles all up (not necessarily 6 of a specific kind), so obviously the discount needs to be calculated on check out in this circumstance.
I need to be able to take items out of the discount equation where the specific column value of DiscExempt is met with the value of 1. I think I can set it up so that the total number of items where DiscountExempt is 0 totals 6 or more or 12 or more, but the discount will be applied to the total value, and not exclude items that are exempt from the discount.
Does that make sense? I just can't see how that kind of calculation can be done within the Merchandising Rule.
