Queries :: Completion - Transformed Query Always Gives 100%

This works:

Code:
SELECT sum(iif(dDateClosed is null,0,1))/sum(iif(dDateFound is null,0,1))*100 AS Calcul
FROM Q_Defects
WHERE (Q_Defects.dAreaFK)=[Forms]![F_MainMenu].[cboStatsArea];

This doesn't, can't find out why...

Code:
TRANSFORM nz(sum(iif(dDateClosed is null,0,1))/sum(iif(dDateFound is null,0,1))*100,0) AS Completion
SELECT sum(iif(dDateFound is null,0,1)) AS [Found], sum(iif(dDateClosed is null,0,1)) AS Fixed, sum(iif(dDateClosed is null,0,1))/sum(iif(dDateFound is null,0,1))*100 AS Compl
FROM Q_Defects
WHERE (dAreaFK=Forms!F_MainMenu.cboStatsArea
OR Forms!F_MainMenu!cboStatsArea IS NULL)
AND (dShiftFK=Forms!F_MainMenu.cboStatsShift
OR Forms!F_MainMenu!cboStatsShift IS NULL
AND month(dDateClosed)=month(Date()))
GROUP BY month([dDateClosed])
PIVOT month([dDateClosed])
IN (1,2,3,4,5,6,7,8,9,10,11,12);