Report on projects with no tasks

[MeganLe1]

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!

[MeganLe1 · Accepted solution]

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

[kynabaker16]

YES. I love that you found your own answer, but even more that you came back to share it with the community!! Thank you!!