Joely Kremer’s Profile

Community member since July 2018

points
10

1

I am in the Medical Device industry. I am looking for some bench marking information around what  a well rounded CAPA system Metric should look like. 

 

For example: What is the typical percentage of CAPA types in your CAPA System. For example: Random numbers here:

78% Corrective

14% Preventive

7%

1

Please, I need help with a formula.

If the status is NOT Complete and the Due Date is IN THE PAST, "Missed". Otherwise it should indicate "On Track".

Criteria:

Status: NOT "Complete", AND Defined Due Date: "In the past", "Missed"

Status: NOT "Complete", AND Defined Due Date: "In the future", "On