Expand my Community achievements bar.

Latest Community Ideas Review is Out: Discover What’s New and What to Expect!

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.