Need help with formula for tiered pricing
Hello, I'm trying to build a formula that will calculate the appropriate pricing based on a tier. So for example, I have the following tiered matrix: <=250,000 transactions * $0.05 <=500,...
Forum Discussion
Thanks for your response!
That was just a typo on my part. What I would like for it to do is when it validates the arguments and runs the calculation for that tier, I also need it to incorporate the pricing for the previous. So, instead of taking all the transactions and multiplying them by the amount for the tier... I need it to calculate the first 250000 at the first pricing, the second level at that pricing and so on.
The way I'm reading it, if the # of transactions are higher than the first tier, it will multiply all the transactions by the amount listed in the tier they fall into which isn't what I'm looking for but I'm not sure how to fix that.
------------------------------
ChristinePratts
------------------------------
That was just a typo on my part. What I would like for it to do is when it validates the arguments and runs the calculation for that tier, I also need it to incorporate the pricing for the previous. So, instead of taking all the transactions and multiplying them by the amount for the tier... I need it to calculate the first 250000 at the first pricing, the second level at that pricing and so on.
The way I'm reading it, if the # of transactions are higher than the first tier, it will multiply all the transactions by the amount listed in the tier they fall into which isn't what I'm looking for but I'm not sure how to fix that.
------------------------------
ChristinePratts
------------------------------
MarkShnier__You
Qrew Legend
Qrew LegendTry this
Min([250000, ) * 0.05 // 5 cents times the smaller of 250000 and the # of Transactions.
+
Max(500000, Max(0,-250000))* 0.03 // the inner max keeps the result above zero, the first max limits to 500000
+
Max(0, -500000) * 0.01 // the max keeps the result above zero
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
Min([250000, ) * 0.05 // 5 cents times the smaller of 250000 and the # of Transactions.
+
Max(500000, Max(0,-250000))* 0.03 // the inner max keeps the result above zero, the first max limits to 500000
+
Max(0, -500000) * 0.01 // the max keeps the result above zero
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
- Thanks. I'll give that a try!
------------------------------
ChristinePratts
------------------------------