Rather than a column specific to buy1Get1, is it possible to create a column that stores an identifier (int) for a range of different offers and then have the discount rule only apply if a product is set to it's corresponding identifier?
So we'd have an 'offers' table in our database:
offerID offertitle offergraphic
1 Buy One Get One Free bogof.jpg
2 10% Discount 10percentoff.jpg
etc
...and then apply the discount calculation if, in the calculation, the correct condition is met?
Considering our 'offers' table above, would I simply change the calculation to?:
abs([offerID] == '1' && [Quantity] >= '2')?[Price]:0
What is this part doing?:
?[Price]:0
I'd appreciate some clarification on the calculation and also what we'd need to do to change that calculation to offer a % discount.
Thank you
NJ