Hello,
I'm trying to find the easiest way to perform a calculation in a report I'm creating. Basically I have a table where there are a bunch of questions that have "Yes", "No" and "N/A" answers. I'd like the report to show, for each record, the % of Yes answers. The "N/A" answers are ignored in the calculation. For example, in the table, if Question1 = No, Question2 = No, Question3 = Yes, and Question4 = N/A, then I'd like the report to show "33%". Seems easy enough but I'm not sure exactly how to go about it/what code to use, etc.
I'm trying to find the easiest way to perform a calculation in a report I'm creating. Basically I have a table where there are a bunch of questions that have "Yes", "No" and "N/A" answers. I'd like the report to show, for each record, the % of Yes answers. The "N/A" answers are ignored in the calculation. For example, in the table, if Question1 = No, Question2 = No, Question3 = Yes, and Question4 = N/A, then I'd like the report to show "33%". Seems easy enough but I'm not sure exactly how to go about it/what code to use, etc.
