True/Total Income Produced By Tech: On the dashboard I want another category for the technicians that takes the sales number, adds it to the productivity number, looks at the productivity number for jobs that are also sales by this specific tech and the split for the tech of the amount of work they performed on that specific sale, then reduces the dollars based on the split that is actually a duplication of the sales in order to come up with a true total income produced by each technician.
Possible Formula: Add Sales Total + Add Productivity dollar amount total = income produced (Look at Sales and Productivity job numbers to identify Dollars based on productivity split by job) - (Productivity job matching job numbers from Income Produced to produce Total income produced by tech. Or something like this since I am not the programmer or mathematician.
Why it is important: How do you have a valid goal to point at or point employees at if the target is not true? My technicians are performance based combining both sales and productivity to be the most fair at having to repair, replace and sell their own work. If these numbers are duplicated then they are invalid, if the numbers are omitted then the tech is being cheated out of possible income and raises. Also I can evaluate techs good and bad as well as company decisions based on these same numbers that will affect everyone at the company.
How ST handles the numbers now: ST separates Sales from productivity or (work performed) Both are valid however if the tech sells the work then performs it, the number based on the split is then doubled based on the split amount. The issue I have is this. I cannot add the 2 categories together to have a total revenue produced by tech. Sales is lower than productivity for most techs and Productivity does not calculate sales if the tech that sold the work does not perform it.
