Hi SHOXF,
what is your intention?
Following example: We have a item ABC (the sales price (per piece) is 10 USD)
1 to 1,000 10% (Range A)
1,001 to 10,000 12% (Range B)
10,001 to (unlimited) 14% (Range C)
What should be the price if someone orders 15,000 pieces?
Version A
=========
- 15,000 is Range C
Apply this 14% to all pieces: (15,000*10 USD) - 14% = 150,000 - 21,000 = 129,000 (Line Amount)
This means a "calculated" price per piece of 129,000 / 15,000 = 8.60 USD (10 USD - 14%)
or did you even mean the following
Version B
=========
For the first 1,000 pieces use Range A, for the next 9,000 Range B and for the remaining 5,000 Range C
First 1,000 pieces ( 1- 1,000) 10% (1,000*10) - 10% = 10,000 - 1,000 = 9,000
Next 9,000 pieces ( 1,001-10,000) 12% (9,000*10) - 12% = 90,000 - 10,800 = 79,200
Next 5,000 pieces (10,001-15,000) 14% (5,000*10) - 14% = 50,000 - 7,000 = 43,000
LineAmount for all pieces in that case would be 131,200 (means a "calculated" price per peace of 131,200 / 15,000 = 8.746 USD
Can you please clarify your intention: Version A or Version B
regards
Douglas