Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
count({<Status={'On Going'}, Ticket={'=Today()-Startline<6 and Today()-Startline>=0'}>}Ticket)
Does not work
Works fine here.