4 Replies Latest reply on Oct 28, 2013 5:56 PM by JimHealey

# Calculate won-loss for group of teams (could also be players)

### Title

Calculate won-loss for group of teams (could also be players)

### Post

I have a group of 4 teams in a football league.  They play each other team once, sometimes twice a season.  I've created a layout for a summary of the scores of individual games.  Now I'm trying to set up a "Standings" report as a sub-summary with Win - Loss - Ties for each team.  I'm not sure of a Repetition is the proper format for the summary, or if there is a better method.  My fields are season (year), sport, Level (varsity, B, etc) and Winner, Loser, Wscore, Lscore.  I have a calculation field for total Wscore and Lscore and a summary of scores as well.  This is easy in Excel, but I'd like to do it in Filemaker and not just create a Filemaker field to hold the Excel summary data, as it seems redundant.

• ###### 1. Re: Calculate won-loss for group of teams (could also be players)

Summary fields can count or sum the wins losses and Ties.

A summary report on a layout with a sub summary layout part for each team and no body layout part can be used to list each team once with the summary fields to show their win/loss stats. This requires sorting by a team name or team ID to group them properly for the sub summary layout part. There is then a "re-order records based on summary field" option that can re order the groups in descending order by the number of wins.

• ###### 2. Re: Calculate won-loss for group of teams (could also be players)

Thanks for you reply.  I'll try this shortly.  A question...do you think it is possible to have this summary be listed before the body, which lists the actual results of each game played?  That's what I'm trying to have occur.

Jim

• ###### 3. Re: Calculate won-loss for group of teams (could also be players)

Yes. I mentioned removing the body layout part as the typical "standings" report that you see in the newspaper has one row of data per team. Just select the "print above" option when setting up the sub summary layout part.

• ###### 4. Re: Calculate won-loss for group of teams (could also be players)

Got it.  Thanks.