4 Replies Latest reply: Feb 27, 2015 7:32 AM by Praveena Kumar RSS

    Expression excluding what contains "x"

    BELEN VERA GARCIA

      Hello

      I know how to exclude ítems that it is ok and works

      sum({$<[Color]={'*'}-{'Red','Blue'}>}

       

      But if i want to exclude for example the ones that contains a "e". I do not know why this formula is not working in the expression.

      Anybody knos why or another way to do it

       

       

       

       

       

      sum({$<[Color]={'*'}-wildmatch(Color,'*e*')>}

       

       

       

      Thanks

       

      Belén