3 Replies Latest reply: Oct 8, 2018 11:36 AM by Casper Westelaken RSS

    Count if equals null()

    Casper Westelaken

      Hello,

       

      I'd like to show the amount of open tickets which do not have an assignee (look at situation below)

       

      To do this I've used the following measure:

       

      count(if([Ticket.Assignee]=null(),[_Flag_TicketOpen]))

       

      But for some reason it does not give the results expected.

       

      In the picture below, in the left table you can see all open tickets. In the right table you can see all unassigned open tickets, in this table the above measure is included.

      In the table underneath you can see that these selected tickets most definitely have a null value as [Ticket.Assignee].

       

      Capture3.PNG

       

      Am I doing something incorrectly? Or is there a better way to achieve this effect?

       

      Yours sincerely,
      Casper Westelaken