**As a** project manager

**I want to** exclude rejected Begin of the insertionor duplicateEnd of the insertion work packages from the calculation of work, remaining work and percentage complete for the parent work packages

**So that I** can clean up my estimates and the progress when rejecting child work Begin of the insertionpackages or marking them as duplicates.End of the insertion Begin of the deletion packages.End of the deletion

**Acceptance criteria**

* Each work package status can Begin of the insertionbeEnd of the insertion Begin of the deletion meEnd of the deletion configured as "exclude from the parent's calculation of completion calculation and work estimates", e.g. for status "rejected". Begin of the insertion
End of the insertion Begin of the deletion
End of the deletion * Begin of the insertionThe children of an excluded work package are not excluded from the calculation. They are excluded only if their status is an excluded status.End of the insertion Begin of the deletion Adapt seed dataEnd of the deletion
* Exclude child work packages that have a status that is marked as "excluded from the parent's calculation..." from the calculation of
* Work
* Remaining work
* % complete
* "Excluding" the work package does not change the attributes of Work, Remaining work and % Complete. They are still visible. Begin of the insertion
* Excluded work packages have a visual clue to show that they are excluded from calculations.
* End of the insertion Reverting the status to another "non-excluded" status includes it in the calculation
* Begin of the insertionChangingEnd of the insertion Begin of the deletion After changingEnd of the deletion the status Begin of the insertionfrom "excluded" to "non-excluded" orEnd of the insertion the Begin of the insertionother way around triggers theEnd of the insertion recalculation of the parent Begin of the insertionand ancestorEnd of the insertion work Begin of the insertionpackages.
* The seed dataEnd of the insertion Begin of the deletion packageEnd of the deletion is Begin of the insertionchanged to mark "Rejected" status as excluded from work calculations.End of the insertion Begin of the deletion triggeredEnd of the deletion
* There is database migration that marks "rejected" status as excluded and recomputes calculated values for work packages using the "rejected" status.

**Out of scope**

* <mention class="mention" data-id="52130" data-type="work_package" Begin of the insertiondata-text="#52130">#52130</mention>End of the insertion Begin of the deletion data-text="#52130">#52130</mention> End of the deletion

**Open**

1. **CB: If an excluded work package has children, those children are considered excluded as well in the calculation even if they have their own non-excluded status, correct?**
NL: no, if a user wants to exclude grandchildren those grandchildren need to be rejected Begin of the insertionas wellEnd of the insertion Begin of the deletion aswellEnd of the deletion
2. **CB: Begin of the insertionRegarding question above, whenEnd of the insertion Begin of the deletion WhenEnd of the deletion a work package Begin of the insertionhaving childrenEnd of the insertion is Begin of the insertionexcluded,End of the insertion Begin of the deletion excluded from calculation, its % CompleteEnd of the deletion should Begin of the insertionits computed valuesEnd of the insertion Begin of the deletion display something different. What about &quot;N/A&quot;?**
NL: no, there mightEnd of the deletion be Begin of the insertioncalculatedEnd of the insertion Begin of the deletion the case that a work package was started until it is 80%End of the deletion and Begin of the insertiondisplayed?**End of the insertion Begin of the deletion then rejected. This is an information which is quite interesting to know. We will add a info to the attribut that explains that we want to add an information that indicates that the value is excluded.
3. **CB: The exclusion is effective regardless of having &quot;Calculate work package % Complete with&quot; being set to &quot;work package status&quot; or &quot;work package field&quot;, correct?**End of the deletion
Begin of the insertion**For instance, are these calculations correct (2 work packages excluded)?:**

<figure class="table op-uc-figure_align-center op-uc-figure"><table class="op-uc-table"><tbody><tr class="op-uc-table--row"><td class="op-uc-table--cell"><p class="op-uc-p">Work package</p></td><td class="op-uc-table--cell"><p class="op-uc-p">Status</p></td><td class="op-uc-table--cell"><p class="op-uc-p">Work</p></td><td class="op-uc-table--cell"><p class="op-uc-p">Remaining Work</p></td><td class="op-uc-table--cell"><p class="op-uc-p">% Complete</p></td></tr><tr class="op-uc-table--row"><td class="op-uc-table--cell"><p class="op-uc-p">parent</p></td><td class="op-uc-table--cell"><p class="op-uc-p">Closed</p></td><td class="op-uc-table--cell"><p class="op-uc-p">1 h - Σ 53h</p></td><td class="op-uc-table--cell"><p class="op-uc-p">1 h - Σ 4h</p></td><td class="op-uc-table--cell"><p class="op-uc-p">100% - Σ 92%</p></td></tr><tr class="op-uc-table--row"><td class="op-uc-table--cell"><p class="op-uc-p">&nbsp; &nbsp;child 1 (excluded)</p></td><td class="op-uc-table--cell"><p class="op-uc-p">Rejected</p></td><td class="op-uc-table--cell"><p class="op-uc-p">2 h - Σ 20h</p></td><td class="op-uc-table--cell"><p class="op-uc-p">1 h - Σ 2h</p></td><td class="op-uc-table--cell"><p class="op-uc-p">50% - Σ 90%</p></td></tr><tr class="op-uc-table--row"><td class="op-uc-table--cell"><p class="op-uc-p">&nbsp; &nbsp; &nbsp; grand child 11</p></td><td class="op-uc-table--cell"><p class="op-uc-p">In progress</p></td><td class="op-uc-table--cell"><p class="op-uc-p">4 h</p></td><td class="op-uc-table--cell"><p class="op-uc-p">1 h</p></td><td class="op-uc-table--cell"><p class="op-uc-p">75%</p></td></tr><tr class="op-uc-table--row"><td class="op-uc-table--cell"><p class="op-uc-p">&nbsp; &nbsp; &nbsp; grand child 12 (excluded)</p></td><td class="op-uc-table--cell"><p class="op-uc-p">Duplicate</p></td><td class="op-uc-table--cell"><p class="op-uc-p">8 h</p></td><td class="op-uc-table--cell"><p class="op-uc-p">1 h</p></td><td class="op-uc-table--cell"><p class="op-uc-p">88%</p></td></tr><tr class="op-uc-table--row"><td class="op-uc-table--cell"><p class="op-uc-p">&nbsp; &nbsp; &nbsp; grand child 13</p></td><td class="op-uc-table--cell"><p class="op-uc-p">Test failed</p></td><td class="op-uc-table--cell"><p class="op-uc-p">16 h</p></td><td class="op-uc-table--cell"><p class="op-uc-p">1 h</p></td><td class="op-uc-table--cell"><p class="op-uc-p">94%</p></td></tr><tr class="op-uc-table--row"><td class="op-uc-table--cell"><p class="op-uc-p">&nbsp; &nbsp;child 2</p></td><td class="op-uc-table--cell"><p class="op-uc-p">In progress</p></td><td class="op-uc-table--cell"><p class="op-uc-p">32 h</p></td><td class="op-uc-table--cell"><p class="op-uc-p">1 h</p></td><td class="op-uc-table--cell"><p class="op-uc-p">97%</p></td></tr></tbody></table></figure>End of the insertion Begin of the deletion NL: The connection between status and percentage is deprecated. We will need to remove first. This is tracked in #52130End of the deletion