Debra,

I figured that out while waiting for a reply but need something more robust.

The report has min, max and count already. I wanted to add field to count
the values that =4, the values that =3, the values =2 and values =1.

Then wanting to add (count of values = 1 or 2 ) divide by total count to
show % of records that failed.

I may be going about this all wrong but if you've got further insight, I'd
certainly appreciate it!

peace,
Kathy