Calculation or Summary Problem
I have what I hope is a straightforward problem but I can't get my head around it at present. In simplified form I have 3 fields in a table - Operator, Action and Error Detected?
Operators enter multiple Actions throughout the day, and occasionally an error is detected, in which case the Error Detected field (a pop up for a Yes/No value List) is changed to Yes.
My problem is this - I need a report/layout that shows me the total number of actions performed, but also the number of errors detected (so only a count of the Error Detected fields showing Yes). I have a summary field showing the total Actions but can't seem to work out how to count only the Yes values in the same found set. I know I could perform a find on the Yes value and get the count that way but then that changes my total number of actions count.
I'm sure it should be a calculation but just can't get it.
Is there a way to count the Yes values when the No values are also showing in the found set?
Thanks in advance.