How to show task percentage in report view?

[DianneCa]

Hi, 

I have a project report that is pulling in the tasks for each project, and I'd like to show the percent complete of each task. Right now I can only get the percent complete of the entire project. 

Any tips appreciated! Here's the logic I'm using: 

aggregator.displayformat=asPercent
aggregator.function=CNT
aggregator.namekey=percentcomp
aggregator.valuefield=percentComplete
aggregator.valueformat=asPercent
descriptionkey=percentcomplete
displayname=Uploaded to Salesforce
listsort=doubleAsDouble(percentComplete)
namekey=percentcomp
querysort=percentComplete
tile.attribute.height=12
tile.name=component.percentcompletelistview
type=tile
valueexpression=IF({templateTaskID}="6849bcfb0002112142720f076aaa35d9",{percentcomplete})
valuefield=percentComplete
valueformat=asPercent
width=80

 

 

[Lyndsy-Denk]

By design, a project report won't be able to pull in much task data. A column in a project report can pull in a collection of tasks and you can lightly format that collection, but that's about it. If you build a task report, though, you can get closer to what you're looking for. I would group your tasks by Project Name and then make sure you have the Percent Complete column in your View.