Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Good day
Kindly assist with this expression:
count({$<[AuditChecklist_Checklist.Answer] = {'$(fmlYes)', '$(fmlCompliant)'} >} distinct [AuditChecklist_Checklist.QuestionID])
/ count({$<[AuditChecklist_Checklist.Answer] = {'$(fmlYes)','$(fmlNo)','NA', '$(fmlCompliant)', '$(fmlNonCompliant)'} >} distinct [AuditChecklist_Checklist.QuestionID])
/*count({$<[AuditChecklist_Checklist.Answer] = {'Yes', 'Compliant'} >} distinct [AuditChecklist_Checklist.QuestionID])
/ count({$<[AuditChecklist_Checklist.Answer] = {'Yes','No','NA', 'Compliant', 'Non-compliant'} >} distinct [AuditChecklist_Checklist.QuestionID])
We would like to include "NA" as a "Compliant" score in this expression.
Regards
You can adjust for numerator
count({$<[AuditChecklist_Checklist.Answer] = {'$(fmlYes)', '$(fmlCompliant)', 'NA'} >} distinct [AuditChecklist_Checklist.QuestionID])
/ count({$<[AuditChecklist_Checklist.Answer] = {'$(fmlYes)', '$(fmlNo)', 'NA', '$(fmlCompliant)', '$(fmlNonCompliant)'} >} distinct [AuditChecklist_Checklist.QuestionID])