Link to home
Start Free TrialLog in
Avatar of dgardner007
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?
Avatar of Will Loving
Will Loving
Flag of United States of America image

So, trying to parse your question here...  you say that "we calculate commission on the job as a whole", and "each one is a separate record",  but then you say that "some individual records within the jobs are calculated at different rate". I think these statement contradict each other...either the commission is calculated as a whole or it's not.

Reading further, and not trying to resolve the above, what if you did a sub-summary Total of the GetSummary calcs?
Avatar of dgardner007
dgardner007

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 TRIAL
Members 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.