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