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.
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
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.
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.
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.