I have created a project report with a custom column to show the number of tasks for each project.
Text Mode for that column:
aggregator.displayformat=int
aggregator.function=MAX
aggregator.valuefield=project:totalTaskCount
aggregator.valueformat=intAsInt
displayname=# of Tasks
textmode=true
valuefield=project:totalTaskCount
valueformat=HTML
What I'm having a problem with, is setting up a filter for that column to only show me projects with 0 tasks. I'm sure I'm missing something super simple, but thought I'd ask for some help before I spend any more time on this.
Thank you!
Solved! Go to Solution.
Topics help categorize Community content and increase your ability to discover relevant content.
Views
Replies
Total Likes
Of course I found my own answer right after I asked for help. If anyone else needs to know, this filter works to find projects without any tasks.
EXISTS:a:$$EXISTSMOD=NOTEXISTS
EXISTS:a:$$OBJCODE=TASK
EXISTS:a:projectID=FIELD:ID
Of course I found my own answer right after I asked for help. If anyone else needs to know, this filter works to find projects without any tasks.
EXISTS:a:$$EXISTSMOD=NOTEXISTS
EXISTS:a:$$OBJCODE=TASK
EXISTS:a:projectID=FIELD:ID
YES. I love that you found your own answer, but even more that you came back to share it with the community!! Thank you!!
Views
Likes
Replies
Views
Likes
Replies