4 Replies Latest reply on Oct 10, 2018 4:40 AM by Sankarmagesh Rajan

    If statement not working

    Frederico Roldao

      Hi,

       

      I have two fields, Purchase Location and Product Location. Both fields are classified as Geography (Country) and both are in ISO 2- letter code for countries.

       

      This is the if cycle:

       

      IF [Purchase Country]=[Product Location]

      THEN "Same Country"

      ELSE "Other Country"

      END

       

       

       

      Once I put them both in rows and I add the field to classify if it's the same country or no, it classifies them all as "Other Country", when for the fields that match, should classify as "Same Country".

       

       

      Can you help me?

       

      Thanks!