dgardner007
asked on
Totaling GetSummary Fields
We have a commission report I am trying to put together. The problem I run into is that we calculate commission on the job as a whole versus separate calculations for the base job, then another calculation for the first change order etc. I have been able to create a report that has each base job and change order listed.(each one is a separate record with the Job# as the common denominator. ) I can list and sort by salesperson and job# but my total is where the problem is. Since some individual records wishin the jobs are calculated at different rates 16% vs 14%, the totals are way off. Is there a way to add up just the GetSummary fields by Salesperson?
ASKER
I will give that a try. You touched on something that may be part of my issue because I might be over thinking it. I was breaking out the commission on each part (change order of the job) but really don't need to. As you state just need to calculate total commission.
This question needs an answer!
Become an EE member today
7 DAY FREE TRIALMembers can start a 7-Day Free trial then enjoy unlimited access to the platform.
View membership options
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Reading further, and not trying to resolve the above, what if you did a sub-summary Total of the GetSummary calcs?