# making a percentage from values.

I have a table that has several fields that have either yes or no in them. I want to know how I can on a report count the number of no's and show that as a percent.. so lets say there are 100 yeses or no's and of that 25 are no's I want to be able to show 25% no's on the answers.
Patrick Matthews

membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
jlcannon

ok well when I use this:
=Sum(IIf([YesNo1] = "No", 1, 0) + IIf([YesNo2] = "No", 1, 0) + IIf([YesNo3] = "No", 1, 0) + IIf([YesNo4] = "No", 1, 0) + IIf([YesNo5] = "No", 1, 0) + IIf([YesNo6] = "No", 1, 0) + IIf([YesNo7] = "No", 1, 0) + IIf([YesNo8] = "No", 1, 0) + IIf([YesNo9] = "No", 1, 0) + IIf([YesNo10] = "No", 1, 0) + IIf([YesNo11] = "No", 1, 0) + IIf([YesNo12] = "No", 1, 0) + IIf([Yesno13] = "No", 1, 0) + IIf([YesNo14] = "No", 1, 0) + IIf([YesNo15] = "No", 1, 0) + IIf([YesNo16] = "No", 1, 0) + IIf([YesNo17] = "No", 1, 0) + IIf([YesNo18] = "No", 1, 0)) / (Count([Yesno1]) * 18)

I get #error displayed when I run the report
SOLUTION

membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.

ok so the control names... ok the fileds in the table are YesNo1 - YesNo18.  What controls am I supposed to name something else.