3 Replies Latest reply: Mar 14, 2016 1:23 PM by Gysbert Wassenaar RSS

    ¿How count with networkdays and other statement?

    Sebastián Garcíá

      Hi Guys,

       

      I need a help to desing the formula to count a number days range with a field filter.

       

      NEED:

      I need to count the quantity of tickets that have the state On Going and are from 0 and 5 networkdays. The count in networkdays is from the "Starline" to Today().

       

      MY SOLUTION:

      Im using the next formula but doses not work:

       

      =Count({$<[Status]={'On Going'},{networkdays(Min(Startline), Max (Today())}={'>-1,<6'}>}[Ticket])

           

      TicketOwnerStartlineStatusNetworkdays
      1Task121/02/2016On Going16
      2Task221/02/2016On Going16
      3Task317/03/2016On Going-4
      4Task417/03/2016On Going-4
      5Task517/03/2016On Going-4

       

      Best regards.