3 Replies Latest reply: Nov 29, 2017 3:22 AM by Naoual EL RHAFFOULI RSS

    Creating a dimension to select a list of values

    Naoual EL RHAFFOULI

      Hello,

      I used this formula to select all the values of my field 'CRM Case Title' that containg the word "test" written in all possible ways

       

      =If([CRM Case Title] like ("*TEST*","*test*","*Test*","*testing*","*TESTING*","*Testing*"),[CRM Case Title])


      This is what I entered when creating a dimension, but for some reason I got error in my expression,

      Could you please help me see what is wrong with my expression?

      Thank you so much,