What is Formula?

A Formula is a secondary measurement that are interdependent with the measurement you have created. Using formula, you can define how commissionable factors will be measured in further detail.

When you create a new Measurement, the system automatically plants a default formula, called ‘sum’. Unless the default formula is used in commission calculations, you can still edit the formula according to your business requirements. This can be found at the very bottom of the Measurement Detail page.

Default Formula: Click Edit to Customize the Default Formula

Default Formula: Click Edit to Customize the Default Formula

Create a New Formula

If you would like to create your own formula, you are more than welcome to do so. In order to create a new formula:

  • Click New link
New Formula Wizard

New Formula Wizard

When filling out the New Formula Wizard, there are couple of things that you should keep in mind.

1. Formula Inherits the Measurement Variable Name

Since a formula is a secondary measurement, it always goes hand-in-hand with the measurement. So, its variable name should look like this:

measurementVariable.formulaVariable

Note: When naming variables, don’t forget to use camel case.

Watermelon may actually replace your buy canada viagra generic for erectile dysfunction by their respective physician because the medicine is completely not seen. This popular and effective erectile dysfunction medicine is now https://www.unica-web.com/watch/2010/in-uhlisko-over-porubka.html cost of prescription viagra out of patent and it is the parent company of this anti-impotency medicine. They are supposed to keep your sexual health good, and enhance it further. purchase generic viagra However, if they persist and pose a serious discomfort, consult your doctor immediately. 100mg viagra is an important drug to many men.

2. Standard vs. Advanced

Within inLOGIC, the most commonly used command in sales compensation such as sum, count and average have been built in. Users can just pick one of these options to apply to their formula. However, for advanced users with more complex compensation rules, inLOGIC leaves an option to create their own formulas using syntax that are permitted to use in the system.

Learn More

3. Discrete vs. Cumulative

Whether you have discrete measures or cumulative measures determines how to define the formula.

By choosing the numbers of the past primary measurements, you can command the system how it should look at to measure the metric.

Select the Number of Past Primary Measurements to Include

Select the Number of Past Primary Measurements to Include

When the plan is discrete, for example, you are measuring the performance of a given period, and payout the commissions for that specific period. Also the credits earned will not affect the future earnings of your sales reps. In such cases, you may choose 1 from the list.

Meanwhile a cumulative formula is used when the past and the current sales activities will have an impact on the future earnings. For example, when you have a quarterly compensation period, and credits earned throughout all four quarters would increase or decrease the final payout amount, you may choose 4 from the list.

4. Sum, Count, or Average

Sum

With sum selected, if you run a calculation, this formula will be triggered and attempt to add up all the values that are drawn as a result of the credit rule that you have defined when creating a measurement.

Count

While sum adds up all the values derived from the credit rule, count commands the system to calculate how many credit-eligible sales activities are in there during the defined period.

Average

The formula average helps you obtain arithmetic mean of the values quickly and easily by dividing sum by count. By using average, you can avoid creating separate formulas in order to get sum and count.

Note: Formulas that are used in Plans will be triggered, and the results can be reviewed in Plan Detail Review pages.