EXISTS filter on projects with hour entries that have $0 Actual Cost | Community
Skip to main content
Level 9
Jul 8, 2020 9:17 PM UTC
Question

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

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

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

3 replies

NickVa7Author
Level 9
Jul 9, 2020 7:23 PM UTC

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

Translate
kynabaker16
Employee
Jul 9, 2020 8:31 PM UTC

You bet!

Translate
kynabaker16
Employee
Jul 8, 2020 9:25 PM UTC

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

Translate