AnsweredAssumed Answered

Find number of related records with a certain value

Question asked by schmity on May 23, 2014
Latest reply on May 24, 2014 by schmity

Title

Find number of related records with a certain value

Post

     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.

      

     thanks!

      

Outcomes