For a report I have made 2 filters (1 on Job Ledger Entry, the 2nd on N018 Time Sheet Lines).
The aim is to find all resource-mutations in both tables, so that I have all resource-costs in my report.
Problem: if there are no entries in the Job Ledger table, entries in N018 TimeSheetLines are ignored.
The report is attached to this posting.
I think the problem is in cell I8, but i don't know how to solve it. I get the "Empty filter not allowed" error which can be solved, but then no data is shown.
I thought the "Union"statement would yield info from both tables, but it seems to work like "And" in Excel.
In K8 is the formula for finding Job Ledger Entries, in K9 for the N018 TimeSheetLines.
What am i doing wrong?
WillemKostenspec tbv JetForum.xlsx
Rgds
Willem
Date
Votes
1 comment
-
Jet Reports Historic Posts It sounds like you need to work with intersect ( those that are in both tables) and difference ( those that are in one table only ) rather than Union
From what you've stated it appears that there maybe time but no material on the job ? but the reverse cannot be true ? If tahst the case a second set of rows based on the differecne should get you the time only data
Please sign in to leave a comment.