Commission Pay minus Hourly (for jobs where commission pay takes over hourly pay when item is sold)

[serranosHVAC]

Is there a way to run a report that calculates employees' pay and takes into consideration that certain items are paid commission which cancels out the hourly pay for the same job where the item was sold?