I have a calculation field named Faculty Whiteboard that specifies "Y" or "N" based on the answer to a survey question.
If (Surveys::_pk_SurveyID = 6 and Questions::Order = 1 and PatternCount(Response; "Attending Name") > 0; "Y" ; "N")
One of the fields in the Respondents table is Faculty Name. I would like to create a report that lists the percentage of "Y" answers for each Faculty Name. I'm not sure the best way to approach this. (Not sure if I've supplied enough info here.)