AnsweredAssumed Answered

It's a simple if. So what's wrong with my logic?

Question asked by pasleeth on Oct 7, 2016
Latest reply on Oct 7, 2016 by philmodjunk

I've been chasing my tail trying to get the syntax right on a simple conditional statement that's one of a string of concatenated tests within a calculation field, and it's just not working.

 

Here it is:

 

If  (  PatternCount ( Group  ; "US"  )  and

 

(  Country_name   ≠ "United States Of America"  or  Country_name   ≠ "Puerto Rico"  )  ;

 

"Living abroad;"  )

 

The field insists on returning the true case "Living abroad;" for instances where the statement is false, i.e., the group contains US and the country name is equal to either of these countries.

 

I've tried stating it as a Case function and every other imaginable permutation, and still the same result.  I can only get it to work by testing for USA or PR and eliminating the "or" operator entirely, but of course that does me no good.  I feel stupid!

 

-- Andrew

Outcomes