Consolidate Code and Finish Your SQL Query

There are, of course, many ways that you could modify this commission structure. Some ideas are:

• Account for different user commission rates
• Account for some items not being commissionable
• Account for whether the customer paid their invoice on time or not

You can view the entire set of code here in our Github repository.

Now that you understand how CRM and Zoho Books data flows into Zoho Analytics, and how to better use SQL and the report builders to automate your commissions, this really is yours for the taking. Use the skills you now have to go design your own commissions reports.