OK, First, you need to determine the maximum number of breaks your products will have, then add three cart columns for each break
so for example, if you will have a maximum of 5 breaks, you need to add 15 column to the cart object, one for each lo point, high point and discount amount.
example:
breakALow
breakAHigh
breakAAmount
breakBLow
breakBHigh
breakBAmount
etc....
Then in the add to cart button you need to set the quantity breaks, for example:
Price = 2.49
breakALow = 1
breakAHigh = 5
breakAAmount = 0
breakBLow = 6
breakBHigh = 11
breakBAmount = 0.31
then you need to create a calculation using the abs function determine which discount amount will be applied:
the basic calculation looks like:
abs([Quantity] >= [breakALow] && [Quantity] <= [breakAHigh])?[Price] - [breakAAmount]:0)
You can expand that for each break set you create like this:
(abs([Quantity] >= [breakALow] && [Quantity] <= [breakAHigh])?[Price] - [breakAAmount]:0) + (abs([Quantity] >= [breakBLow] && [Quantity] <= [breakBHigh])?[Price] - [breakBAmount]:0))
name this calculation realPrice.
in the cart display, swap out the price display with the realPrice display.
yopu will also need to change the TotalPrice calculation to incorporate the real Price calculation:
(abs([Quantity] >= [breakALow] && [Quantity] <= [breakAHigh])?[Price] - [breakAAmount]:0) + (abs([Quantity] >= [breakBLow] && [Quantity] <= [breakBHigh])?[Price] - [breakBAmount]:0)) * [Quantity]
