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

    Calculate Win % Help

    clabbers

      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
          TSGal

          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. 

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