How Can I Calculate a Complicated Per-Transaction Reward (Advanced)?

How Can I Calculate a Complicated Per-Transaction Reward (Advanced)?


Sometimes, you want to calculate per-transaction commission amounts based on complex rules.



Do You Need A Per-Transaction Reward Formula?
In most cases, it's sufficient to rely to use pre-canned rewards such as "% of Revenue", "% of Profit", or "Cash Reward". Those options do not require formulas.



However, you may want to calculate commission amounts using formulas. This can be achieved by defining either a/ a global reward or b/ a per-transaction reward. This article describes option b/ (per-transaction reward). Click here for the other option, and here to determine if you are using the right approach.

Creating a Per-Transaction Reward Formula
First, review this article about formulas to understand how they work, and which constructs are available.

Next, create a per-transaction reward formula:
  • Edit your plan
  • Click on the "Incentives" tab (if needed)
  • Click on the "+ Reward" button
  • Select "Per-Transaction Reward"
  • Enter a per-transaction formula (examples below)

Your formula's output should be numeric.

Pay attention to this option. The first option will apply your payouts to ALL transactions (not just those which fall within the current tier). The second option will only apply your payouts to transactions which fell within the current tier.



Per-Transaction Reward Formula Examples
Here are some examples of formulas you could use to configure per-transaction rewards.

Assume that you uploaded transactions with the following fields:
  • Product (a text field)

Apply The Beneficiary's Commission Rate To Revenue
var $rate = [Beneficiary].[@@Rate]
--------------------------------------------------------------------
[Transaction].[calculated_revenue] * $rate / 100.0

Use Fixed Commissions Depending On The Product
var $product = [Transaction].[Product (Imported)]
--------------------------------------------------------------------
IFEX($product LIKE '%apple%', 10)
--------------------------------------------------------------------
IFEX($product LIKE '%orange%', 20)
--------------------------------------------------------------------
0

    • Related Articles

    • How Can I Calculate a Complicated Global Reward (Advanced)?

      Sometimes, you want to calculate a total (gross, lump sum) commission amount based on complex rules. Do You Need A Global Reward Formula? In most cases, it's sufficient to rely to use pre-canned rewards such as "% of Revenue", "% of Profit", or "Cash ...

    • Recipe - How To Store Per-Transaction Values

      This article describes a recipe to store per-transaction values. For example, you could calculate a "Commissionable" amount once and store it. You can then re-use this value within different reward formulas, or perhaps simply show it to payees. ...

    • Should I Use Per-Transaction Rewards?

      When adding certain types of rewards, you can specify whether rewards should be calculated per-transaction. The short answer is - if it's important for reps to see a per-transaction commission amount (and rate), then you should check the checkbox, ...

    • Recipe - How To Store Per-Calculation Values

      This article describes a recipe to store per-calculation values. Typically, you want to store a value a/ for a given calculation and b/ for a given user or team. For example, you could calculate each user's average credited revenue and store this. ...

    • How Can I Configure Per-Transaction Limits?

      Here are the steps to configure per-transaction limits for your sales incentive plan: Login to your workspace On the left pane, click on "Plans > All Plans" Search for the plan Click on the plan row Click on the "Limits" tab (if needed) Select ...