2 Replies Latest reply on Jul 21, 2009 3:11 PM by clabbers

# Calculate Win % Help

### Title

Calculate Win % Help

### Post

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

• ###### 1. Re: Calculate Win % Help

clabbers:

Without knowing how your tables are set up, Player 1 will either have a higher score than Player 2, or a lower score.  In either words, and either/or situation.  Therefore, a calculation field resulting in type Number could be:

If ( Score > Opponent Score ; 1 ; 0 )

If you then create a Summary field that averages the calculation field, you will get a win percentage.  That is, if Player 1 wins 3 times and loses 1, the average of 1, 1, 1, and 0 is .75 or 75%.  Does that make sense?

TSGal

FileMaker, Inc.

• ###### 2. Re: Calculate Win % Help
yes...this made perfect sense and worked on my first attempt....thank you!