7 Replies Latest reply: Aug 6, 2014 6:45 AM by Yousef Amarneh RSS

    Conditional Count expression

    Jan Ulrych


      I am new to QV world just learning basics. I am looking for help with conditional count expression. Searched here, but did not find what I needed.

      I have two data columns - Name and Certification date. I want to create text box showing count of Names that are not certified (= empty cell for Certification date). What is the right syntax for expression?

      Also what the right expression would be if I want this shown as percentage from total of Names?

      Thanks for help.