count different values in a column

[former_member1368488]

How can you count the different variables for a single column.

I want count the number of "yes" and "no' to then to convert to a percentage.

I am unable to count the different values under the "Compliance Column, appreciate some help.

Compliance Yes No No No Yes Yes

[mynynachau]

The tag "SAP Community" does not seem suitable. Please check available tags that suit your question better: https://answers.sap.com/tags.html

Then, please edit your question, by clicking on "Actions" and then "Edit" to update the tag.

If the tag is not being changed within the next 7 days, your question will be removed.

You might want to check out this tutorial about asking questions: https://developers.sap.com/tutorials/community-qa.html

Best regards

Mynyna (SAP Community Moderator)

[agentry_src]

I would suggest that you provide more information on what database and/or which tables you wish to query.

Cheers, Mike

[DellSC]

And which type of reporting tool you're using.