For anyone referencing this in the future, here is the final text mode that worked: EXISTS:1:$$OBJCODE=PROJEXISTS:1:ID=FIELD:projectIDEXISTS:1:ID_Mod=inEXISTS:1:program:name=Non-BillableEXISTS:1:program:name_Mod=cinotcontains Thanks Skye for getting me on the right path.  The only item missing from ...

Odd, eh?!I stripped the filter down to remove the couple other straightforward criteria I had in there, so that it just contained the rejigged EXISTS code you suggested, and it didn't work.I'll reach out to support.Appreciate the time, thanks!

Thanks, Skye.  That looks logical, and the report doesn't error out, but it turns up zero records when run.  I tried taking out the "ci" (case insensitive), but same result.

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=NOTEXISTSEXISTS:1:$$OBJCODE=PROJEXISTS:1:ID=pr...

Hi WF Community, I have a project report that has a custom number field called "Burned Hours %". In that report I have a custom calculated column ("BURN BAR", as note in the above screenshot) whereby I am trying to display a progress bar indicator based on the value in the "Burned Hours %" column.  ...

Unfortunately this gives me the mean average.  Similar to applying the "Average" option on the 'Sum this column by' feature.  It adds all of the values within the grouping and divides it by the number of records. I'd like to take the sum 'Total Actual HRS PRGM' field value at the parent grouping lev...

Thanks for the response, @KatherineLa .  I'll give this a try.

Hi WF Community,I noticed that when I have a field that contains a value as a percent, when I include it in a report and want to get a percent value at the grouping level it's wrong. Example: When I use the "Average" option on the 'Sum this column by' options for the '% On Hours Used' column, it jus...

Thanks everyone!Yes, Doug's solution is actually simpler.But good callout, Skye - using NOTEXISTS and yes, semantics in this case matters.

Hi WF Community!I'm trying to build a report that shows me all projects with an open status, but all tasks within these projects are marked complete. I have a project report and have been working with EXISTS in text mode, but can't seem to get the results I need:EXISTS:1:$$OBJCODE=TASKEXISTS:1:statu...