1 Reply Latest reply on Oct 25, 2012 11:43 AM by Tracy Rodgers

    Filtering based on "OR" logic instead of "AND"

    Thai Huynh

      I need to find records where

           Field-A has "string1" OR Field-A has "string2"

           OR

           Field-B has "string1" OR Field-B has "string2"

           OR

           Field-C has "string1" OR Field-C has "string2"

       

           etc...

       

      I used "Set" to filter but those are "AND" logic and I can't use more than one field in the formula. I would get this error message:

       

      "The formula must be an aggregate calculation or refer to only this field"