AnsweredAssumed Answered

Trouble with Calculation ("and" "or" "xor")

Question asked by disabled_RPeters on Mar 28, 2016
Latest reply on Mar 30, 2016 by disabled_RPeters

Hi Everyone,


I’m having some difficulty with a calculation.  I’m keeping track of donations by individuals and each individual has a status.  I’m looking for a group of individuals who donated $500+ in 2015, and also donated $500+ in any other past year.  Their status should read “Donated in 2015, has donated in the past”.


This is the calculation I’m using but it doesn’t seem to work.  It’s part of a larger case, and the case has been working perfectly so far.  This is my first glitch.


Case (


Donation 2015  ≥  500




Donation 2014 ≥ 500


Donation 2013 ≥ 500


Donation 2012 ≥ 500


Donation 2011 ≥ 500


Donation 2010 ≥ 500


Donation 2009 ≥ 500


Donation 2008 ≥ 500


Donation 2007 ≥ 500 ;


"Donated in 2015, has donated in the past" ;


and then the case continues on from there.  It’s giving the “Donated in 2015, has donated in the past” status to people who haven’t donated in 2015.  I just can’t quite wrap my mind around what I've done incorrectly.


I’m pretty new to Filemaker, so any help would be very much appreciated!