1 Reply Latest reply: Apr 27, 2012 9:57 AM by Celambarasan Adhimulam RSS

    Check if text contains certain words

    Guy Vermeiren

      Hello,

       

      If have a calculated dimesion where i want to check on the content of the fields.

       

      Example:

       

      I have a number of "Trainings":

       

      "Advanced training electronics"

      "Advanced training mechanics"

      "Basic training electronics"

      "Basic training mechanics"

      "Specialists training"

       

      Now I want to create a calculated dimension where I get Null() if the trainingname contains "Advanced training"

       

      Thanks for your help on the formula.

       

      Kind regards,

      Guy