Hi All,
I'm trying to identify all expense reports that contain just 1 specific expense type. If I filter by the expense type i.e. airfare, it shows me all reports that have airfare and may have additional expenses as well. I need to identify reports that don't have any expense other than airfare. It can have multiple lines for airfare but cannot have any lines for other expense types.
Thanks
You need a report with three queries.
Q1 has column Document ID, and filter Expense Type = airfare
Q2 has column Document ID, and filter Expense Type <> airfare
Q3 has all the columns needed by your report, and two filters:
- Document ID in (Q1.Document ID)
- Document ID not in (Q2.Document ID)