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

    Count Multiple Conditions

    Jordan Konicki



      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!