When 1 plus 1 isn't 2

I need to run checks on data for accuracy. I’m getting conflicting figures so at this stage I’m convinced it’s my logic that’s the problem and I could do with a bit of help.

I have two tables. One is Employees with a field that is a list of Courses they have attended.

The second table is a list of Courses with a field that is a list of Employees who attended.

I do a Do a Search for Employees with constraint Courses is empty and get a result X.

Then I Do a Search for Employees:filtered Uniquie ID isn’t in Do a Search for Courses Employee’s Unique ID and get a result Y.

The problem is that X + Y are not equal. So where am I going wrong?

Solved - it was me - using :filtered incorrectly :wink:

1 Like

This topic was automatically closed after 70 days. New replies are no longer allowed.