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.