If you look at the code, I have already added the fields on select and group by statements. But now I'm not getting the %compliance I needed.

For example, it's showing 100% compliance for all supervisors.

AASHEIM, DONNA J.100.00%1000.00% 100.00%

MARTIN JJACOB 8788888

JOEL ABRAHAM 8968598

ADAM, JANICE G. 100.00%1000.00% 100.00%

CYNTIA SUNNY 7898888

AMBURGEY, DAVID A.100.00%100.00%100.00%

GEORGE MANUEL 87969096

JIM PONDER 67488888

SUZANNE MASON 97578588

ANDERSON, PATRICIA100.00%100.00%100.00%

LINDA FoGUS 74848888

CHAR CONNER 89947889

SAM SON 78848888

KATHY MAHER 9899888

When I remove name and id fields from the select statement and group by, then I'm getting the correct result

AASHEIM, DONNA J.100%100%100%

ADAM, JANICE G. 100%100%0%

AMBURGEY, DAVID A.92.7%96.3%88.9%

Let me know