IF with No Match

[Aldemarprins4]

Hello guys, I have the following problem, I have two countries that I want to exclude with an IF NO MATCH THEN, is it possible to do it?

Thank

[AshutoshBhumkar]

Hello,

If you want to exclude data in backend, you can use not match or not wildmatch.

e.g 

Load

Country, CITY, Sales

From[................] where not match(Country,'A','B')

If from frontend then use '-='

E.g  Sum({<Country - = {'A','B'}>}Sales)

Hope this helps.

Thanks,
Ashutosh

[Aldemarprins4]

Thank  but

I can do the following statement:

If(Not match ('Vcountry)'='Colombia',CostaRica'))

[MarcoWedel · Accepted solution]

If(not Match(Vcountry,'Colombia','CostaRica'), then this, else that)

[Aldemarprins4]

Thanks a lot