AnsweredAssumed Answered

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

Question asked by RPeters on Mar 28, 2016
Latest reply on Mar 30, 2016 by 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

 

and

 

Donation 2014 ≥ 500

or

Donation 2013 ≥ 500

or

Donation 2012 ≥ 500

or

Donation 2011 ≥ 500

or

Donation 2010 ≥ 500

or

Donation 2009 ≥ 500

or

Donation 2008 ≥ 500

or

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!

 

Thanks!!

-Rachael

Outcomes