Text mode for task report to exclude tasks from programs containing certain words

[NickVa1]

Hi WF Community,

I'm looking to create a task report that excludes tasks from projects that belong to programs with the words "Non-Billable" in the program name.

The closest I've gotten on this is with the following text mode filter:

EXISTS:1:$$EXISTSMOD=NOTEXISTS
EXISTS:1:$$OBJCODE=PROJ
EXISTS:1:ID=projectID
EXISTS:1:ID_Mod=in
EXISTS:1:program:name=Non-Billable
EXISTS:1:program:name_Mod=cicontains

It doesn't error when I run the report, but it doesn't filter out tasks from programs containing "Non-Billable" in the program name

Any ideas on where I might be going astray?

Thanks!
Nick

[skyehansen]

I think you should just go with:

EXISTS:1:$$OBJCODE=PROJ
EXISTS:1:ID=projectID
EXISTS:1:ID_Mod=in
EXISTS:1:program:name=Non-Billable
EXISTS:1:program:name_Mod=cinotcontains