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
Solved! Go to Solution.
Topics help categorize Community content and increase your ability to discover relevant content.
Views
Replies
Total Likes
Views
Replies
Total Likes
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.
Views
Replies
Total Likes