
1. Re: Tiered Volume Based Discounting
Don Wise Jun 29, 2018 2:16 PM (in response to tarang.patel.3)Hello Tarang,
See if the attached works for you? If so, please mark this response as correct. Thanks Don

TS1.twbx 14.4 KB


2. Re: Tiered Volume Based Discounting
tarang.patel.3 Jun 29, 2018 3:26 PM (in response to Don Wise)Hi Don,
Thanks for your help. This was pretty close, but it should be incremental. So, for Option A, the first ten are priced at $50/unit and the 11th is priced at $48/unit.

3. Re: Tiered Volume Based Discounting
Don Wise Jun 29, 2018 5:34 PM (in response to tarang.patel.3)Hello Tarang,
I understand now what you're trying to achieve and I gave it a go with use of the Modulo function. Essentially, it evaluates the number of units and determines whether it can divide it to 0. If not, meaning there's a remainder, then the value falls into the next bucket (range of discounts). Then they're added together (the value that was able to be divided by 0 plus the value of the remainder) for your final discount value.
Unfortunately, I've hit a wall with this calculation. So hopefully someone else will pick up the flag and carry it forward for you. Below is the calculation I worked up, but I'm hitting a "can't compare boolean and integer value" error:
IIF(INT([Units]>0 % 0==0 AND INT([Units]<10 %10 == 0,.50
+ IIF(INT([Units]>11 % 11==0 AND INT([Units]<20 %20 == 0,.48
+ IIF(INT([Units]>21 % 21==0 AND INT([Units]<50 %50 == 0,.46
+ IIF(INT([Units]>51 % 51==0 AND INT([Units]<100 %100 == 0,.44
+ IIF(INT([Units]>100 % 100==0 AND INT([Units]<200 %200 == 0,.42
+ IIF(INT([Units]>200 % 200==0,.44)))))))))))))))))
Maybe we'll both learn something! Thx, Don