6 Replies Latest reply: Aug 15, 2012 5:29 PM by Alexander Karlsson RSS

    Expression syntax to exclude specific data set

      We have case numbers that I need to exclude from my trending.

       

      Case numbers examples:

       

      G2012-02534

      G2012-03456

       

      We have cases (addendums) where the case adds a .1 to the case number which need to be excluded from the query.

       

      Case number examples to exclude from query

       

      G2012-02534.1

      G2012-03456.2

      etc...

       

      How I exclude '.#' cases in this statement:

       

      count(distinct WP_CaseTable.Number)