Wildcard question

[#1]

I have a straight table chart where I am trying to filter out a value using a wildcard.  What I am trying to do is exclude any instances of where the field value has TEMPLATE somewhere within in it.

Here is an example of a field value that I am trying to exclude:

PRJ-10014 - TEMPLATE - Management Activities

I attempted to created a calculated dimension

=If ([Proj Number & Name] <>'*TEMPLATE*', [Proj Number & Name])

but it is ignoring the wildcard.

Any help would be greatly appreciated.

[#2 · Accepted solution]

=If (substringcount([Proj Number & Name],'TEMPLATE')=0, [Proj Number & Name])

[#3]

Perfect - thanks!