AnsweredAssumed Answered

Calculating Wins and Loses

Question asked by ScottLee on Aug 26, 2014


Calculating Wins and Loses


     Hi there,

     I am extremely new to filemaker but trying to learn on my own.

     I am creating a betting pool with my friends for this upcoming football season.  I want to calcuate how many picks a person got right based on calculating their weekly record and then calculating their overall record.  I know this is simple but I can't seem to figure it out.

     The fields I want to evaluate in my layout "week 1" are:

     Winner - Team that covered the spread

     Scott - What team I picked that week


     The first thing I did was create a calculation field(Scott Weekly TrueorFals) with  If(Week 1::Winner = Week 1::Scott; 1; 0).  This told me if I picked the correct team I got a 1 and if I did not I got a 0.

     Then from there I want to calculate how many 1's (wins) and then how many 0's(loses) there are for the week.  This is the part im stuck on.

     Can someone please help me?

     Thank you in advance.