Creating a new database to track commissions on closed deals. We are using Zoho CRM and Zoho Creator.
Have much of it laid out, need help with logic and calculations.
This is phase 1 of a larger project. We have 4 product lines and 5 different types of DEALS.
I want to get the database up and working using this one DEAL type and then we can add the other DEAL types.
The attached file shows what information would be enetered on a PJM DEAL and the back end calculations and how they are generated.
There are the reports i would like to receive for the payments