3 Replies Latest reply on Dec 30, 2014 3:19 PM by Theresa Dzieciatkowski

    How can I create a calculated field that will count rows where a date is missing?

    Theresa Dzieciatkowski

      Hi, I am trying to build a report that has the following rows:

       

      Date Created: Date the issue was created

      Date Completed: Date the issue was resolved

      IssueID: Distinct ID to identify the issue

       

      I want to find the number of open issues. I thought I would count the distinct IDs where Date Completed was null but any equation I use ends up in an error.

       

      Can somebody point me in the right direction? This is the equation I have been trying to use:

       

      CASE IFNULL([Date Completed],00/00/0000 )  WHEN 0 THEN COUNTD([Issue ID] ) END

       

      Thank you, Theresa