Expand my Community achievements bar.

The next phase for Workfront Community ideas is coming soon. Learn all about it in our blog!

EXISTS filter on projects with hour entries that have $0 Actual Cost

Avatar

Level 10

Hi WF Community,

I've been reading over Tony Messam's Leap presentation slides in an attempt to try and create the following project filter:

  • Projects that have hour entries that have $0 in the hour's Actual Cost field

I have this so far, but it error's out:

EXISTS:1:$$OBJCODE=HOUR

EXISTS:1:ID=FIELD:projectID

EXISTS:1:actualCost=0

Anyone have an idea where I'm wrong?

Thanks.

Nick

Topics

Topics help categorize Community content and increase your ability to discover relevant content.

3 Replies

Avatar

Employee

Hey Nick,

If you post this question on his Q&A post directly you'll probably get an answer from Tony himself!

If you want to try that!

Kyna

Avatar

Level 10

Sweet, I didn't know he had his own thread. Thanks, Kyna.