2 Replies Latest reply: Mar 15, 2012 1:22 PM by Shannon Lepore RSS

    Wildcard question

      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.