13 Replies Latest reply: Oct 5, 2018 10:35 AM by Sunny Talwar RSS

    Excluding row from count if specific column is null

    Casper Westelaken

      Hello reader,

       

      I'm trying to exclude a row from a count if a specific column in this row is null.

      More specifically to better describe the situation:

      Service management, assigned and unassigned incidents. I'd like to count the tickets per priority that have been assigned to an employee.

       

      count(${<[Incident.HuidigeActeur]<>null>}[_Flag_IncidentGesloten])

       

      This is the formula I was trying to use (apologies for the Dutch field names)

       

      To test whether or not it actually was excluding the null values I created the table below.

       

      Capture2.PNG

       

      As you can see it is still counting the incidents that do not have an employee assigned to it. This makes me feel that my Set Analysis is incorrect, but if I'm doing something else incorrect please do inform me.

       

      I've also tried the following formula:

       

      count(${<not isNull([Incident.HuidigeActeur])>}[_Flag_IncidentGesloten])

       

      Does anyone know how I can achieve this?

       

      Yours sincerely,

      Casper Westelaken