I have a database that keeps track of all NCAA College Football games.

I have created summary fields to track Total of wins and Total of losses. This gives

me two fields from which I can utilize in two more calculation fields using

the GetSummary command.

this works fine. I get the proper getsummary data with the breakfield being

"Team" This basically creates a win/loss record for each team.

My problem is when I try to define a GetSummary using the "Opponant" field

as the breakfield. What I get is nothing. What am I doing wrong?

I have attached a copy of the file for anyone to tweak to show me what I have done or failed to do.

Thanks

scheduledata.zip

Your file appears to be working fine. The Opponent summaries are calculating correctly on my computer, in the file you attached.

The problem you are experiencing lies with the data. In order to get the relevant summary calculations to work, the file must be sorted by the summary target field. Null fields come to the top in a search and there are two records for which the opponent field is blank. If you move through to the third and subsequent records when the file is sorted by opponent, you will see that the summary data is appearing correctly there and throughout the rest of the file.

Since an opponent summary for a record in which the opponent has not been specified makes no sense, it is appropriate that the summary data for these first couple of records be blank. If you put in a field validation requiring that the opponent field be filled in, that should help you to avoid a recurrence of this issue.

I see now by sorting the Opponant fields as well, that I get results, but that only means I am half of the way there.

If you notice that the second post Air Force is the team, and the opponant is California. The summary stats in the unsorted calc fields win_sumdata and loss_sumdata show data from all posts, which in this case is 3 wins and 0 losses for Air Force.

The Opponant data however only shows the total results against the Team or Air Force in this case. So the owin_sumdata and oloss_sumdata fields show California in this case to have 0 wins and 1 loss. Against Air Force this is true, but I want to see the win loss total for the Opponants entire schedule.

owin_sumdata and oloss_sumdata should produce in this case:

owin_sumdata = 3 ; oloss_sumdata = 1 (this is a mirror of the win_sumdata and loss_sumdata fields in posts 51-54 where the team is California.)

that I am getting a breakdown of Air Forces wins against their opponants, and not their opponants records against their opponants opponants, which is what I want.