Content
View differences
Updated by Christophe Bliard over 2 years ago
See ##40867 for the full picture.
* "derived work"
* unset or 0h is the same. It does not count.
* sum from derived work of direct children + self work
* "derived remaining work"
* 0h is actually meaningful here
* sum from derived remaining work of direct children + self remaining work
* "derived % complete"
* (sum(derived work \* derived % complete) for direct children + (work \* % complete) for parent) / parent derived work
* Yes, it's a weighted average. Average of % complete, weighted by work. If work is 0h, then it's out of the equation.
* special case when all of the children have unset Work: No more weight, it's simply an average of the % complete
* 0h leads to unset value
* it would be nice to make it automatic with a recursive sql statement
Questions
* The case of mixed set and unset Work values should be clarified
* "derived work"
* unset or 0h is the same. It does not count.
* sum from derived work of direct children + self work
* "derived remaining work"
* 0h is actually meaningful here
* sum from derived remaining work of direct children + self remaining work
* "derived % complete"
* (sum(derived work \* derived % complete) for direct children + (work \* % complete) for parent) / parent derived work
* Yes, it's a weighted average. Average of % complete, weighted by work. If work is 0h, then it's out of the equation.
* special case when all of the children have unset Work: No more weight, it's simply an average of the % complete
* 0h leads to unset value
* it would be nice to make it automatic with a recursive sql statement
Questions
* The case of mixed set and unset Work values should be clarified