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

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

    JimHealey

      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.