Hello! I have a list report that one particular column will contain either 'Y', 'N', or 'N/A'. I need to display the percentage of each response based on the total responses. Is there a consolidated way to do this?
Thank you in advance.
Hi,
Assuming there is another column which is unique in the list (Staff Code for example), you could try the following:
Add a calculation called Response Percent with the expression count([Staff Code] for [Your Y/N/NA Column]) / count([Staff Code] for report)
Format this as percentage.
Does this give you what you need?
MF.