Recipe - How To Store Per-Transaction Values

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.

Storing Per-Transaction Values
You can store calculated per-transaction values within:

To store your value within the transaction, use the StoreTransaction(Name, Value) function. Specify a name and the value to store.

For example, you could specify a scoring formula like this to store a value called "Commissionable" within each transaction:

Loading Per-Transaction Values
You can now load per-transaction stored values within:

To load values from your transactions, use the [Transaction].[Name] convention.

For example, you can load each transaction's "Commissionable" value in a per-transaction reward formula:

For example, you can use the same convention to load each transaction's "Commissionable" value in a global reward formula:

Exporting Credits
When exporting credits from a calculation, calculated fields are automatically included in the export:


Displaying Stored Values
To display the calculated field on incentive dashboards, you need to specify an advanced option on your plan. The convention is CreditingFieldShow=<Name> (ex: CreditingFieldShow=Commissionable).

    • Related Articles

    • 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 ...
    • 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, ...
    • 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 ...
    • Recipe - How To Efficiently Setup A New Plan

      This article describes a recipe to efficiently create plans based on common patterns. Those patterns work for 75% of plans. This article is intended to be a compact reference and provide general guidelines. Initialize Plan The goal here is to quickly ...