Ignore rolled-up progress values in formulas
Voting Open
When a formula uses the task progress value, it makes no distinction between manual (user-entered) progress values and rolled-up (calculated) values. If task roll-up is enabled in the same tree as a formula that reads progress values across descendants, this leads to incorrect results. A rolled-up task is treated as a manual task, resulting in double-counting and skewed averages. Preferably, the formula should ignore rolled-up progress values. At the moment I can't think of a use case for a formula that counts or calculates progress of both manual tasks and rolled up tasks.
This is a good idea but I think the choice to include or exclude rolled-up task values should be optional, and the ability to do the opposite (ie, apply the formula only to rolled-up values) should be an option as well.
I take your point about the potential for double-counting when using formulas to establish averages, sums or counts of progress values at the central or main topic level in sub-topics if rolled-up values in parent topics can't be excluded. However, I can think of a few formulas that would be useful at the parent or sub-topic level regardless of whether a roll-up is involved.
One example would be where a simple formula is used, say, to create a topic property to show progress on individual topics as a percentage value. This sort of formula may in fact be more useful at times at the rolled-up level.
This is a good idea but I think the choice to include or exclude rolled-up task values should be optional, and the ability to do the opposite (ie, apply the formula only to rolled-up values) should be an option as well.
I take your point about the potential for double-counting when using formulas to establish averages, sums or counts of progress values at the central or main topic level in sub-topics if rolled-up values in parent topics can't be excluded. However, I can think of a few formulas that would be useful at the parent or sub-topic level regardless of whether a roll-up is involved.
One example would be where a simple formula is used, say, to create a topic property to show progress on individual topics as a percentage value. This sort of formula may in fact be more useful at times at the rolled-up level.
---