Using Filemaker 9, I have a calculation that summarizes data based on date and and a dollar amt to determine a sales persons commission. For example, if the salesperson books between 13 and 20 loads the sales person gets an extra $25 a day. I have that working fine:

Case (GetSummary(Total Booked; PU Date) ≥ 13 and GetSummary(Total Booked; PU Date) < 20; 25; 0)

It finds a salesperson and sorts by date & puts the subsummary at the bottom of each date correctly. But I also want a grandtotal, so at the end of the week it adds up each of the days. The problem is the summary field doesn't add it correctly because now it's doing it over. Am I missing something? I can have it export the subtotals and import them to a total in a script everytime it runs but it's not a pretty solution. Any ideas?

Thank you !

Caroline

See if this helps:

http://fmforums.com/forum/showtopic.php?tid/209850/post/334676/#334676