I would like to show:
- Total Number of Vendors
Defined as the # of vendors in each cohort. This lives on a tab called “Vendor - Main View”
- Total Number of those Vendors with Completed “AERs”
AER Completion is defined as a date corresponding to the Step 27 shown here in the table named “Checklist v2.0”. (An empty cell implies the step is incomplete)
The thought is that we’d show “Of the 12 vendors in the January cohort, only 9 of them have completed AERs” “Of the February Cohort, 2 have completed AERs”.
Thanks in advance for your help!