4 Replies Latest reply: Oct 5, 2016 8:52 AM by Jeferson Nunes Jaconetti RSS

    If with two conditions

    Jeferson Nunes Jaconetti

      Hello Everyone.

       

      I'm trying to count a field with two conditions. How can I do that?

       

      The field to be counted is [Ticket ID] and the conditions are State = ' New' and the diference between Now() and [Creation Date] > 30.

       

      Count(if(State='New' AND interval(now()-[Creation Date], 'DD') > 30),[Ticket ID]))

       

      Thank you.