9 Replies Latest reply: Nov 28, 2017 11:15 PM by Naoual EL RHAFFOULI RSS

    How to exclude items when the title contain a specific string

    Naoual EL RHAFFOULI

      Hello,

      I would like to calculate the sum of items, but only when their title doesn't include a specific string.

      for example, here is my list

       

      Titlenumber
      Banana20
      Apple10
      Apple Test15
      Strawberry1
      Mango testing2
      test2

       

      So basically what I want is to have only Banana + Apple +Strawberry and ignore anything that contains "test" in it.

      It's just an example, my table got hundreds of lines.

       

      I tried this

      Sum({$<SubStringCount([Title], 'test')={0}>}[number])  but it doesn't seem to be working.

      Any idea?

      Thank you so much