Calculate Win Percentage

[clabbers]

I am new to FMP and am building a db that will record stats for Scabble. I am trying to calculate the win percentage.

So if i have player 1 and player 2 fields, how do i calculate the number of times player 1 score is greater than player 2 and express it as a percentage?

Any help would be greatly appreciated.

Cheers

Mark

Edited July 20, 2009 by Guest

[mr_vodka]

Assuming that you have a game table for each game played, you can use calcs to mark who won. Then you can use a summary field to do the average wins across the found set of games.