5 Replies Latest reply on Oct 7, 2016 7:10 AM by philmodjunk

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

    pasleeth

      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