4 Replies Latest reply: Jan 3, 2013 8:13 AM by Darwin Natividad RSS

    Set Analysis (Does Not Contain)

    Darwin Natividad

      Hi,

       

      Does anybody know how to do this using set analysis.

       

      I am trying to count records where a certain field does not start with 'Q:'

       

      I have something like this but seems not working

       

      count({<left(Name,2)-={'Q:'}>} Id)