Fobio,
CAST(SUM(IIF(result="Fail",1,0)) AS I) Fail
please convert this line of code as
TRANSFORM(roun((SUM(tobt)/SUM(tmax))*100,2),"##.##") AS PERCENTAGEu,;
str((SUM(tobt)/SUM(tmax))*100,4,2) AS PERCENTAGEi;