3 Replies Latest reply: Jun 1, 2018 9:46 AM by Pratyush Shastri RSS

    Multiple IF statements for a background color expression

    John Murphy

      I have a data table with addresses where I need to look for and abbreviate certain words, in various countries.

       

      I have created an IF statement that works, but only for 1 country;

       

      However, I have tried various ways of adding further IF statements to this for the other countries, but they seem to cancel each other out.

       

      So basically I have 5 country codes (AT, BE, GB, NL, DE)  each with it's own set of words that I would like to highlight when that particular country code is selected from the 'CountryFilter' field.

       

      Is it possible to insert multiple if statements here, or is there a better way of going about this?

       

      Any suggestions would be much appreciated.