Hi,

It is possible to have computed columns in a view. If you tried directly 1/N; PA1R/N then you probably had an error message.

create view vwPAScores

as

SELECT TOP (100) PERCENT VolunteerID, Class, NoWeek, PA,

(SELECT COUNT(*) AS Expr1

FROM dbo.tblPAScores

WHERE (PA > X1.PA) AND (Class = X1.Class) AND (NoWeek = X1.NoWeek)) + 1 AS PA1R,

(SELECT COUNT(VolunteerID) AS Expr1

FROM dbo.tblPAScores AS tblPAScores_1

WHERE (Class = X1.Class) AND (NoWeek = X1.NoWeek)) AS N,

1/(SELECT COUNT(VolunteerID) AS Expr1 FROM dbo.tblPAScores AS tblPAScores_1 WHERE (Class = X1.Class) AND (NoWeek = X1.NoWeek)) as [1_divide_N],

(((SELECT COUNT(*) AS Expr1 FROM dbo.tblPAScores WHERE (PA > X1.PA) AND (Class = X1.Class) AND (NoWeek = X1.NoWeek)) + 1)-1)/(SELECT COUNT(VolunteerID) AS Expr1 FROM dbo.tblPAScores AS tblPAScores_1 WHERE (Class = X1.Class) AND (NoWeek = X1.NoWeek)) as [PA1R-1_divide_N]

FROM dbo.tblPAScores AS X1

ORDER BY NoWeek, VolunteerID