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.
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...