Calculate won-loss for group of teams (could also be players)
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.