EXISTS statement for hour entries with no billing records

[NickVa1]

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

[Doug_Den_Hoed__AtAppStore · Accepted solution]

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

[NickVa1]

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.