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

    If with two conditions

      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.