So right now I'm using the following code to display the number of tasks added on to a project beyond the original template.
aggregator.displayformat=int
aggregator.function=SUM
aggregator.namekey=totalTaskCount
aggregator.valueexpression=SUB({totalTaskCount},14)
aggregator.valueformat=int
displayname=Touchpoints
namekey=totalTaskCount
querysort=totalTaskCount
valueexpression=SUB({totalTaskCount},14)
valuefield=totalTaskCount
valueformat=int
viewalias=totalTaskCount
This works fine, but if the number of template tasks ever change from 14, the number in the column will be wrong.
What I'd like to do is change the value expression to count the number of children tasks under a specific parent task. However, I'm not sure how to go about writing that expression since I'm looking for a task name on a project report. I would be able to figure it out with nested lists, but I'm new to aggregates.
