Dashboard - add/include "NA" as a factor 1 to score

[Thea3]

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

[Chanty4u]

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])