Expression excluding what contains "x"

[#1]

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

[luciancotea · Accepted solution]

sum({$<[Color]={"*"}-{"*e*"}>} ...

[mukesh24]

Hi u can use following:-

sum({<[Color]={"*"}-{"*e*"}>}

[Anonymous]

Hi

Try

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

-= is equavalent of not equal to sign

[praveenak]

Hi

Use

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