3 Replies Latest reply on Aug 14, 2018 2:16 PM by Chris McClellan

    Case Contains for more than 1 value?

    Ben Perlman

      I'm looking to only count 3-4 values in a certain field, else null.  I know the formula for looking for 1 value, but how would I do this when it could be one of multiple?

       

      I tried "or" but that doesn't work.  It should say, if the field contains either "example 1" or "example 2" or "example 3" then true else null

       

      CASE CONTAINS([Tfh Result],"RPC") WHEN  TRUE then "RPC"

      ELSE NULL END