### 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

clabbers:

Thank you for your post.

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.