Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

SOLVED

EXISTS statement for hour entries with no billing records

Avatar

Level 9

Hi WF Community,

I'd like to create a report that uses an EXISTS statement to show me hour entries that aren't associated to a billing record.

I have the following text mode filter so far, but it's not filtering properly and just showing me hour entries without billing records:

EXISTS:A:$$EXISTSMOD=NOTEXISTS

EXISTS:A:$$OBJCODE=BILL

EXISTS:A:ID=ID

project:entryDate=$$TODAYbw

project:entryDate_Mod=between

project:entryDate_Range=$$TODAYew

Does anyone know where I might be off path?

Thanks.

Nick

Topics

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

1 Accepted Solution

Avatar

Correct answer by
Level 10
Hi Nick, Since Billing Record ID is on each Hour (that’s what “ties them” together), I think this filter should suffice: billingRecordID_Mod=isblank Regards, Doug

View solution in original post

2 Replies

Avatar

Correct answer by
Level 10
Hi Nick, Since Billing Record ID is on each Hour (that’s what “ties them” together), I think this filter should suffice: billingRecordID_Mod=isblank Regards, Doug

Avatar

Level 9

Hey Doug!

Funny enough, that was the first thing I tried, and it didn't work. However, I now know what was missing - some test data, in Sandbox where I was testing, that qualified 😉

Thanks for pushing me back in the right direction.