Forum Discussion
ChristinePratt1
6 years agoQrew Cadet
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
------------------------------
AustinK
6 years agoQrew Commander
I had wrote something out but it seems like you may have something wrong in the formula. Is just the number of transactions?
What you would want to have there is the "Spend/Cost/Amount" field for the specific record you are working on. Not the number of transactions but the actual dollar amount for that specific transaction.
Are these single large purchases or is this like a client that has a subscription with you(or someone else) where they are spending that amount over the whole year?
What you would want to have there is the "Spend/Cost/Amount" field for the specific record you are working on. Not the number of transactions but the actual dollar amount for that specific transaction.
Are these single large purchases or is this like a client that has a subscription with you(or someone else) where they are spending that amount over the whole year?