First, make sure you choose the right rep field for your integration. For example, there might be a rep field on both the customer and a rep field on the transaction in your data. Make sure you use the right field for your particular use case:

Next, you need to choose what field you're paying out commission on. Is it on total sales, gross profit, or something else? If you need to exclude a certain set of products, you can use a field level filter to excludee those products from the total.

Once you know what field is driving the calculation, how are you calculating the percentage? If each rep is paid the same rate, you can do Custom Field -> Add Custom Measure and simply do a calculation along the lines of:

[Total Sales] * .2

To calculate a 20% commission. If you need to set a specific percentage per rep, you can create a custom field within Easy Insight. Make sure to base your custom field on the right rep field, customer or transaction rep. Set the values per rep:

Once those values are set, you can reference the custom field you created in your commission formula:

[Total Sales] * ([Commission Percentage] / 100)

Next, let's look at some more advanced scenarios. Let's say you want to pay 20% for customers who pay over $10,000 in sales in the time period, and 10% for less than $10,000:

if ([Total Sales] > 10000, [Total Sales] * .2, [Total Sales] * .1)

In the above example, make sure customer is in your commission report to keep the calculation valid. Otherwise, it'll sum up the values across all customers without using the appropriate percentage per customer.

As another example, you might pay 15% for customers newer than 12 months and 12% for customers older than 20 months. Your integration should have a date field in it along the lines of 'First Order Date' in the Customers section:

Using that field, you can do a calculation along the lines of:

if (daysbetween([First Order Date], nowdate()) < 365, [Total Sales] * .15, [Total Sales] * .12)

Finally, make sure to use the right date field for your commission statement report. Is it payment date, invoice date, order creation date, or something else?