Access 2016 - Eliminate "N/A" from count

[Treeivery]

Hello,


I'm new to this forum and to access. I'm attempting to create a quality assurance report that shows "N/A", "Met", and "Not Met" measures.
I have two issues:

1) When calculating percentage of Met, I need to exclude records from the count where "N/A" is reflected, otherwise it will penalize the worker. As in the
case below where the worker has 3 cases marked "N/A" he should have a result of 83% because of 5 "Met" and 1 "Not Met".
When using the unbound textbox in the form footer my text is "=Sum(IIf([Accurate Symptom Duration]="Met",1,0))*100/Count(*)"

2) If I left a measure blank, meaning that that element wasn't assessed, it would still penalize the worker because the count of overall records would still be 9 records instead of 6.

Whatever assistance would be greatly appreciated.

[pbaldy]

How about:

=Sum(IIf([Accurate Symptom Duration]="Met",1,0))*100/Sum(IIf([Accurate Symptom Duration]="N/A",0,1))

[Bulzie]

Just filter the Recordsource on the form to exclude measures with "N/A" and Nulls? That way you are only dealing with "Met" and "Not Met".

[Treeivery]

I implemented your recommendation. It works perfectly Thanks

How about:

=Sum(IIf([Accurate Symptom Duration]="Met",1,0))*100/Sum(IIf([Accurate Symptom Duration]="N/A",0,1))

[Treeivery]

I tried that, however, filtering gives you an undesired result as it suppresses the count of other records where conditions are either met or not met. Thanks!

[pbaldy]

I implemented your recommendation. It works perfectly Thanks

Happy to help!

[Bulzie]

Won't you get an error if the 2nd part tries to divide by 0?