Similarly to the Simple Inventory Views, where you use addition, subtraction, and division to follow Inventory levels, you can also use multiplication in Analytics.
A common application of multiplication is in employee commission, where employees receive a percentage of their total sales. To create a basic commission report:
- Open your Employee Team Performance Report located under the Employee Performance Reports. In this report, you can view employees' total dollar sales, total hours worked, sales by hour, profit by hour, and basket size.
- Remove the measures that you don't need in this report, for example: Total Hours Worked, Sales by Hour, Profit by Hour, and Basket Size.
- Optionally, if you base your commissions on profit instead of total sales, to add this, navigate to Sale Line > Totals > Profit.
- Click Calculations in the Data header bar.
- Search for total Sales or total Profit depending on how you base your commissions. For example, the profit calculation should be: ${cl_employee_sales_dates.total_profit}
Next, for example, if employees get a 4% profit commission, to create this, add an asterisk symbol (*) to represent multiplication, and 0.04 to make 4%.
In Analytics, percentages are functions of 1, so 100% is 1, 50% is 0.5, 5% is 0.05, 0.5% is 0.005, and so on.
- Save the calculation, and a new green column displays on your report titled Calculation 1.
- Optionally, to make the report easier to read, click Calculations > Default Formatting, and change the number formatting from Default Formatting to your currency of choice, like U.S. Dollars.
Also, rename Calculation 1, for example, to 4% Commission. Save the report again, and the formatting will be more readable.
You can enhance Commission reports in many different ways, for example:
- Use IF statements to create tiers of Commission(such as: $1000+ returns 2.5%, $2,500+ returns 5%, and so on).
- Use IF statements to add bonuses to top sales employees or employees with the highest basket sizes.
- Create a floating commission rate that highlights how an employee's performance compares to the rest of the group.
- Give different commission rates to different categories of products, different shops, or to different employee Roles.
- Define certain employees as managers whose commission may be implicit in their team's overall performance.