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 · Accepted solution]

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.

[kautuk_sahni]

@DianneCa Just checking in — were you able to resolve your issue?
We’d love to hear how things worked out. If the suggestions above helped, marking a response as correct can guide others with similar questions. And if you found another solution, feel free to share it — your insights could really benefit the community. Thanks again for being part of the conversation!