Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Thank but
I can do the following statement:
If(Not match ('Vcountry)'='Colombia',CostaRica'))
If(not Match(Vcountry,'Colombia','CostaRica'), then this, else that)
Thanks a lot