Forum Discussion
Countrows
see if the attached helps.
Thanks for your support.
In your workfile, the activities that had target dates January 2023 were all closed within the target (four activities were even closed in December 2022).
Your table, however, shows 16 activities closed on time instead of 20
How can activities closed early be included in the calculation?
Thanks in advance!
All the best
I thought you wanted to exclude the items with an empty closed_dt ?
Hello!
Yes, items with still empty closed_date should be excluded but I need activities closed early to be counted; for example, activities with target_date January2023 and closed in December2022 should be counted in addition to the activities closed in January2023 itself.
Thanks in advance!
All the best
yes, that's what "Closed on time" does, no?