Percentage of field with several possible values

[Tseug]

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.

[MFGF]

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.