3 Replies Latest reply: Nov 19, 2015 5:28 PM by Stefan Wühl RSS

    Count Multiple Conditions

      Hello,

       

      This expression is building off one of my previous ones, but I'm making sure that I have the syntax right. The conditions should be:

       

      1. STATUS_TITLE must be one of these: 'Pending Certification', 'Pending Completion', 'Pending Qualification'

       

      2. CERTIFICATION_DATE must be either: ' ' or '0'

       

      If these two are met, then it should count RTC_TITLE.

       

      This is my equation so far:

       

      =Count({$<STATUS_TITLE = {'Pending Certification', 'Pending Completion', 'Pending Qualification'}, CERTIFICATION_DATE = {'', '0'}  >} RTC_TITLE)

       

      It keeps throwing straight 0's though which is not correct.

       

      Any help is appreciated!

       

      Thanks!