That worked.....I ended up doing this:

Declare @Denominator int, @NumeratorT int, @NumeratorT1 int

SET @Denominator = (SELECT COUNT(*) FROM TestScores.dbo.Analysis)

SET @Numerator = (SELECT SUM(t_complete) TestScores.dbo.Analysis)

SET @Numerator = (SELECT SUM(t1_complete) TestScores.dbo.Analysis)

SELECT Distinct LEFT(CONVERT(DateTime, IndexDate , 110), 11)AS IndexDate,

COUNT(*) AS No_Records,

Round(AVG(Test1),2) As Test1_AVG,

Round(AVG(Test2),2) AS Test2_AVG,

SUM(t_complete/COUNT (*)) As Percent_Complete

SUM(t_complete) As Initial_Completed,

CONVERT(Decimal(5,3),@NumeratorT/(@Denominator* .01)) As PercentComplete,

SUM(t1_completed)AS Repeats_Completed,

CONVERT(Decimal(5,3),@NumeratorT1/(@Denominator*.01)) AS Repeats_Percent,

FROM TestScores.dbo.Analysis

Group by IndexDate

Thoughts?