alexanderthegreat
IS-IT--Management
SELECT
( SELECT SUM(aes.S2C_TTL) FROM dbo.AES_ES_2 AS aes )
+ ( SELECT SUM(aes.S2C_TTL) FROM dbo.AES_HS_2 AS aes )
AS TotalArtsSpending / (Select ENROLL_TT from AES_CONTACT_SCHOOL)AS PerPupilSpending
Im trying to take the sum of two fields and divide by another while assigning a new name to each calculaton
( SELECT SUM(aes.S2C_TTL) FROM dbo.AES_ES_2 AS aes )
+ ( SELECT SUM(aes.S2C_TTL) FROM dbo.AES_HS_2 AS aes )
AS TotalArtsSpending / (Select ENROLL_TT from AES_CONTACT_SCHOOL)AS PerPupilSpending
Im trying to take the sum of two fields and divide by another while assigning a new name to each calculaton