AnsweredAssumed Answered

Calculation Confusion - and/or/xor

Question asked by RPeters on Jul 5, 2016
Latest reply on Jul 6, 2016 by RPeters

Hello Filemaker Friends,

 

I'm having some issues with my and/or/xor statements, and I've come to realize that I really don't understand how to use them like I thought I did!  Oh boy, I'm getting myself good and mixed up!

 

I'm trying to hide the _EventsIDfk field when the Account Number field is not one of the four listed below.  In addition, I want the field to hide if it's empty.  I thought I had it sorted out, but after about half an hour of playing around in the "Hide when" option box with switching "and"s to "or"s and "xor"s to "or"s, and throwing in brackets here and there for good measure, I've accepted the fact that I really don't know what I'm doing.

 

Income::Account Number ≠

"41 120 Box Office - Other Concerts"

or

"41 100 Box Office Summer Festival"

or

"44 100 Fundraising Events Revenue"

or

"Concert Host"

xor

IsEmpty ( Income::__EventsIDfk )

 

Any ideas on why this isn't doing what I want it to be doing??

Outcomes