I have a table named Licenses with a Current? field [Yes|No]. The table is linked to the Employees table by the Employee # field.
For each Employee, there could be a License record with:
I need a formula, which will I will use as a filter, that returns a Boolean if the Employee doesn't have a Current? = Yes row.
Essentially, I need a list of Employees that don't have a current license.
How should I approach this?
In your 'Employee', create a "Count" field and give it a conditional of "Current = 'Yes'". This'll output the number of Liceneses with the value "Yes", then you can filter by this field to get the employees that don't have a current license
In your 'Employee', create a "Count" field and give it a conditional of "Current = 'Yes'". This'll output the number of Liceneses with the value "Yes", then you can filter by this field to get the employees that don't have a current license
I actually need this filter in the Licenses table. Can your approach be modified to do so?
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
