Count of Parent task if status = complete, however, if the children tasks are cancelled, need to exclude those. | Community
Skip to main content
N
nsoans1106
Level 2
June 14, 2021
Question

Count of Parent task if status = complete, however, if the children tasks are cancelled, need to exclude those.

  • June 14, 2021
  • 1 reply
  • 459 views

I am trying to build a report where I am counting the total change rounds for a project. In the template, I have configured it to have 3 change rounds by default (parent task= Change round). I have built a report which counts any parent tasks with "Change round" in it and the status = CPL. However, when I cancel the children tasks under lets say Change Round #3, the parent task still shows up as complete. So in my report I always see 3 change rounds being done. Is there a work around to this one?

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

1 reply

Doug_Den_Hoed_AtAppStore
Community Advisor
Doug_Den_Hoed_AtAppStoreCommunity Advisor
Community Advisor
June 14, 2021

Hi Nelson,

I suspect that marking a parent Task as Complete when all the subtasks are Cancelled is As Designed, so suggest you either (procedurally) delete such a parent task (and its subtasks), or rename them in a way (such as typing "CANCELLED" at the end of the parent Task) that then allows you to then exclude them in the report filter (e.g. Name does not contain CANCELLED).

Regards,

Dough

Terms & ConditionsAccessibility statement

Loading footer...