Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I want to count the field that contained the char which like this.
Count(WildMatch(Interest.source, 'Non-'))
Is this the correct way to do because i have not use wildmatch function before and not sure how it is work.
Thanks by the way.
HI!
It's much easier.
Try this:
Count({<Interest.source={"Non*"}>} Interest.source)
Sergio S.
HI!
It's much easier.
Try this:
Count({<Interest.source={"Non*"}>} Interest.source)
Sergio S.
Sergio gave you a better option, but you can also do this :
Count(WildMatch(Interest.source, 'Non*'))
Hi ,may be it works
load *,
if(wildmatch(Intrest.source,'Non-*'))as Filter from location;
=>in text box you can take =>count(Filter)
You could also try this:
Sum(If(WildMatch(Interest.source,'Non*'),1,0))