**Problem**

* The sum includes values from children that are not part of the filter result
* The sum includes values from children twice that are part of the filter results.

Begin of the insertion



End of the insertion Begin of the deletion 

End of the deletion **Expected behavior**

* Values are not added twice
* The sum only includes the shown/filtered work packages

Begin of the insertionEnd of the insertion Begin of the deletion End of the deletion

**Proposed solution**

Begin of the insertionThe cell is split intoEnd of the insertion Begin of the deletion We haveEnd of the deletion two Begin of the insertionparts:

1. Value for the estimated time of the respectiveEnd of the insertion Begin of the deletion separateEnd of the deletion work package Begin of the insertion(editable)
2. ValueEnd of the insertion Begin of the deletion attributesEnd of the deletion for estimated time Begin of the insertionderived from children (read only).End of the insertion Begin of the deletion and spent time.End of the deletion

Begin of the insertionExpected behavior for

End of the insertion * Begin of the insertionThe sum does not includeEnd of the insertion Begin of the deletion Spent time - total: Aggregated values of spent time includingEnd of the deletion the Begin of the insertionderivedEnd of the insertion values Begin of the deletion of childrenEnd of the deletion
* Begin of the insertionItEnd of the insertion Begin of the deletion Spent time: Only the spent time thatEnd of the deletion is Begin of the insertionpossible to editEnd of the insertion Begin of the deletion logged on this work package
* Estimated time - total: Aggregated values includingEnd of the deletion the Begin of the insertionestimated timeEnd of the insertion Begin of the deletion valuesEnd of the deletion of Begin of the insertionparent elementsEnd of the insertion Begin of the deletion childrenEnd of the deletion
* Begin of the insertionWhen adding a children to a work packageEnd of the insertion Begin of the deletion Estimated time: OnlyEnd of the deletion the estimated time Begin of the deletion thatEnd of the deletion is Begin of the deletion entered on this work package (read only)

In the work package list sums areEnd of the deletion not Begin of the insertiondeleted.End of the insertion Begin of the deletion allowed for aggregated  values. It is possible to create sums for the column spent time.

**Out of scope**

Currently value for "Progress (%)" get lost when children are added. This is OK for now.End of the deletion