5 Replies Latest reply on Mar 16, 2016 6:34 AM by Shinichiro Murakami

    Problem in Contains Function

    Abinesh Sathish

      Hi friends

       

      I need to show the values which should be filtered by two columns

       

      And  more over that should be in calculated Column

      I am using this below expression but I didn't get my result.

       

      IF CONTAINS ([RESOLUTION],"HIGH") AND CONTAINS ([TYPE],"COMPLAINT") THEN  [NAME]  END

       

      This expression give output as values of NAME where [Resolution] = "High" it didn't consider [TYPE] can you please help me  on this how can I write condition by using two columns and show the Single value

       

      Please help ASAP its too imp..