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

# ¿How count with networkdays and other statement?

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])

 Ticket Owner Startline Status Networkdays 1 Task1 21/02/2016 On Going 16 2 Task2 21/02/2016 On Going 16 3 Task3 17/03/2016 On Going -4 4 Task4 17/03/2016 On Going -4 5 Task5 17/03/2016 On Going -4

Best regards.

• ###### Re: ¿How count with networkdays and other statement?

count({<Status={'On Going'}, Ticket={'=Today()-Startline<6 and Today()-Startline>=0'}>}Ticket)

• ###### Re: ¿How count with networkdays and other statement?

Does not work

• ###### Re: ¿How count with networkdays and other statement?

Works fine here.