8 Replies Latest reply: Jan 31, 2017 2:12 AM by Dennis Odenbreit RSS

    How to search for wildcards in set-analysis?

    Dennis Odenbreit

      Hi,

       

      I have fields containing the value '?'.

      Now I want to count those fields like:

       

      count({1<[Field] = {'?'}>} [Field])

       

      But this does not only apply to fields with '?', it interpretates the ? as a wildcard and sums up other fields like 'a' and 'b'.

      The question is, how can I write the {'?'} expression, so that I get what I want?

       

      thanks