Finding a percent in a pivot table

[Miked]

I have multiple queries that have data which was accumulated. I was able to
calculate the totals of each field at the bottom. However I now need to find
percent. When a person selects "no", it enters a 1 in the box, and totals
the number of "no" answers. Now I need the percent of "NO" answers when
compared to the total number of entries. So how would I divide the 2 Total
fields to find the percent. I have been playing with the Create a calculated
field, and the autocalc sections, but I just can't figure it out. Any input
on this matter would be helpful.

 

[th0r0n]

Hello there Miked.

I have a similar field in my Database.

I have Total: [field1] + [field2] etc... which adds up the 0's and 1's that
are Yes/No (In a query)

What I do then, is divide total by the number of questions!

So it would read like this:

In the QDE:

Total: [field1] + [field2]

Percentage: Total/2

And that should automatically display the percentage, if not, just set the
control it's displayed in's format to percentage, or x 100.

Regards,

Toby