How to create a checkbox that checks for one of several attributes within a field?

Permanently deleted user

March 25, 2019 19:52

I am trying to create a checkbox in a report that fills in when one of several attributes (USA, England, or Italy) are the value of a string field (Country) of a polygon. I am able to get the box to check when only one attribute is queried for using the calculated field formula:

 

((Country + " ").ToString().Trim() = "USA")

 

I have tried using an IN expression and OR expression but either that is not the correct way to write the formula, or I was writing it incorrectly. Ideally, the box will check when either USA, England or Italy is the attribute for the "Country" field.

 

If I haven't been clear enough, please let me know. Any guidance would be greatly appreciated.

 

Thank you,

 

Patrick

0

• 

  Berend Veldkamp

  March 26, 2019 13:25

  You could turn it around and try something like this: (new[] {"USA", "England", "Italy"}).Contains(Country)

   

   

  0

Please sign in to leave a comment.