Using a filter column for posting date to prevent duplicates MAX("Requisition Posting"."Posting Date

Summary

Using a filter column for posting date to prevent duplicates MAX("Requisition Posting"."Posting Date") and reqs only posted once are showing blank

Content

Right now, I'm using a filter column for posting date to prevent duplicate rows - MAX("Requisition Posting"."Posting Date") is showing the most recent posting date for reqs that have been posted more than once. BUT the issue is that for reqs that have only been posted once are showing as blank (it looks like they have never been posted).

I'm having an issue with blanks on a requisition report. Has anyone run into the same issue or can think of a better solution for this?