Find number of related records with a certain value
Trying to find a way to count the number of records with a certain value in one field.
Table 1- Work Orders
Table 2 Discrepancies
Each work order is related to many discrepancies.
I have a field in the work order table that shows the total number of related discrepancies.
Each discrepancy has a status field that can only be set to "Open" or "Closed". How can I write a calculation to show the total number of related records with a status of "Closed"?
Basically trying to show a percentage complete for each work order.