Content
View differences
Updated by Christophe Bliard almost 2 years ago
**As a** project manager
**I want to** exclude rejected or duplicate work packages from the calculation of total work, total remaining work and total % complete for the parent / ancestors work packages
**So that I** can clean up my estimates and the progress when rejecting child work packages or marking them as duplicates.
### Summary
It's possible to mark some status as "excluded from totals calculation". When a work package has this status, the parents of this work package will not include it in the calculated sum of Work and Remaining work.
This is useful when having estimated some work packages at the beginning of a project, and then in a later sprint the team decides to not do some work packages and update total estimate for the sprint. They can set their status to "Rejected", and as this status has the "exclude from totals calculation" being enabled, the totals will be updated so that the work packages with "Rejected" status are not counted.
### **Acceptance criteria**
* Each work package status can be configured as "exclude from the parent's calculation of completion calculation and work estimates", e.g. for status "rejected".
* The children of an excluded work package are not excluded from the calculation. They are excluded only if their status is an excluded status.
* Exclude child work packages that have a status that is marked as "excluded from the parent's calculation..." from the calculation of
* Total work
* Total remaining work
* Total % complete
* "Excluding" the work package does not change the attributes of Work, Remaining work and % Complete. They are still visible.
* Excluded work packages have a visual clue to show that they are excluded from totals calculation.
* When a work package table view displays the sum row, the sum is for all work packages, even the ones excluded from parent's calculation
* Reverting the status to another "non-excluded" status includes it in the calculation
* Changing the status from "excluded" to "non-excluded" or the other way around triggers the recalculation of the parent and ancestor work packages.
* The seed data is changed to mark "Rejected" status as excluded from work calculations.
* ~~There is database migration that marks "rejected" status as excluded and recomputes calculated values for work packages using the "rejected" status.~~ (removed, see comment 27)
* Journals messages have to be adapted as now there can be 2 different changes for a status:
* when updating % complete: "**Status 'Rejected'** % complete changed from 30% to 50%"
* when checking excluding from totals: "**Status 'Rejected'** now excluded from hierarchy totals"
* when unchecking excluding from totals: "**Status 'Rejected'** now included in hierarchy totals"
* when updating % complete and checking excluding from totals: : "**Status 'Rejected'** % complete changed from 30% to 50% and now excluded from hierarchy totals"
* when updating % complete and unchecking excluding from totals: "**Status 'Rejected'** % complete changed from 30% to 50% and now included in hierarchy totals"
### Design
[https://www.figma.com/file/znrocQvFNLb5jXRXNo7oeD/Progress-estimation?type=design&node-id=1225-32825&mode=design&t=nLYtgOyq4RP97xpj-4](https://www.figma.com/file/znrocQvFNLb5jXRXNo7oeD/Progress-estimation?type=design&node-id=1225-32825&mode=design&t=Q4lvreP9j7xBEjek-4)
<img class="op-uc-image op-uc-image_inline" src="/api/v3/attachments/100357/content"> <img class="op-uc-image op-uc-image_inline" src="/api/v3/attachments/100359/content"> <img class="op-uc-image op-uc-image_inline" src="/api/v3/attachments/100353/content">
**I want to** exclude rejected or duplicate work packages from the calculation of total work, total remaining work and total % complete for the parent / ancestors work packages
**So that I** can clean up my estimates and the progress when rejecting child work packages or marking them as duplicates.
### Summary
It's possible to mark some status as "excluded from totals calculation". When a work package has this status, the parents of this work package will not include it in the calculated sum of Work and Remaining work.
This is useful when having estimated some work packages at the beginning of a project, and then in a later sprint the team decides to not do some work packages and update total estimate for the sprint. They can set their status to "Rejected", and as this status has the "exclude from totals calculation" being enabled, the totals will be updated so that the work packages with "Rejected" status are not counted.
### **Acceptance criteria**
* Each work package status can be configured as "exclude from the parent's calculation of completion calculation and work estimates", e.g. for status "rejected".
* The children of an excluded work package are not excluded from the calculation. They are excluded only if their status is an excluded status.
* Exclude child work packages that have a status that is marked as "excluded from the parent's calculation..." from the calculation of
* Total work
* Total remaining work
* Total % complete
* "Excluding" the work package does not change the attributes of Work, Remaining work and % Complete. They are still visible.
* Excluded work packages have a visual clue to show that they are excluded from totals calculation.
* When a work package table view displays the sum row, the sum is for all work packages, even the ones excluded from parent's calculation
* Reverting the status to another "non-excluded" status includes it in the calculation
* Changing the status from "excluded" to "non-excluded" or the other way around triggers the recalculation of the parent and ancestor work packages.
* The seed data is changed to mark "Rejected" status as excluded from work calculations.
* ~~There is database migration that marks "rejected" status as excluded and recomputes calculated values for work packages using the "rejected" status.~~ (removed, see comment 27)
* Journals messages have to be adapted as now there can be 2 different changes for a status:
* when updating % complete: "**Status 'Rejected'** % complete changed from 30% to 50%"
* when checking excluding from totals: "**Status 'Rejected'** now excluded from hierarchy totals"
* when unchecking excluding from totals: "**Status 'Rejected'** now included in hierarchy totals"
* when updating % complete and checking excluding from totals: : "**Status 'Rejected'** % complete changed from 30% to 50% and now excluded from hierarchy totals"
* when updating % complete and unchecking excluding from totals: "**Status 'Rejected'** % complete changed from 30% to 50% and now included in hierarchy totals"
### Design
[https://www.figma.com/file/znrocQvFNLb5jXRXNo7oeD/Progress-estimation?type=design&node-id=1225-32825&mode=design&t=nLYtgOyq4RP97xpj-4](https://www.figma.com/file/znrocQvFNLb5jXRXNo7oeD/Progress-estimation?type=design&node-id=1225-32825&mode=design&t=Q4lvreP9j7xBEjek-4)
<img class="op-uc-image op-uc-image_inline" src="/api/v3/attachments/100357/content"> <img class="op-uc-image op-uc-image_inline" src="/api/v3/attachments/100359/content"> <img class="op-uc-image op-uc-image_inline" src="/api/v3/attachments/100353/content">