July 20, 200916 yr Newbies 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, 200916 yr by Guest
July 21, 200916 yr 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.
Create an account or sign in to comment