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.