Calculation Syntax for Discoverer
OIRA
March 9, 2011

Copy and paste the syntax into a Discoverer calculation window to compute a new data point.

**********************************************
Institution Graduation Rates
**********************************************

3-Yr Institution Rate (%):
100*(SUM(CASE WHEN Cohort Facts."Year 3 Outcome Category Code" ='01'
	THEN "Year 1 Fall - Headcount" ELSE 0 END) )
	/SUM("Year 1 Fall - Headcount")
	
4-Yr Institution Rate (%):
100*(SUM(CASE WHEN Cohort Facts."Year 4 Outcome Category Code" ='01'
	THEN "Year 1 Fall - Headcount" ELSE 0 END) )
	/SUM("Year 1 Fall - Headcount")
	
5-Yr Institution Rate (%):
100*(SUM(CASE WHEN Cohort Facts."Year 5 Outcome Category Code" ='01'
	THEN "Year 1 Fall - Headcount" ELSE 0 END) )
	/SUM("Year 1 Fall - Headcount")
	
6-Yr Institution Rate (%):
100*(SUM(CASE WHEN Cohort Facts."Year 6 Outcome Category Code" ='01'
	THEN "Year 1 Fall - Headcount" ELSE 0 END) )
	/SUM("Year 1 Fall - Headcount")

X-Yr Institution Rate (%):
100*(SUM(CASE WHEN Cohort Facts."Year X Outcome Category Code" ='01'
	THEN "Year 1 Fall - Headcount" ELSE 0 END) )
	/SUM("Year 1 Fall - Headcount")
	
**********************************************
System Graduation Rates
**********************************************

*****Version 1 - Year X using Graduation Category Code

3-Yr System Rate (%):
100*(SUM(CASE WHEN (Cohort Facts."Year 1 Fall - Degree Pursued Level Code"='2'
	AND Cohort Facts."Year 3 Graduation Category Code" IN ('3','4') )
	OR (Cohort Facts."Year 1 Fall - Degree Pursued Level Code"='3'
	AND Cohort Facts."Year 3 Graduation Category Code" ='4' )
	THEN "Year 1 Fall - Headcount" ELSE 0 END) )
	/SUM("Year 1 Fall - Headcount")
	
4-Yr System Rate (%):
100*(SUM(CASE WHEN (Cohort Facts."Year 1 Fall - Degree Pursued Level Code"='2'
	AND Cohort Facts."Year 4 Graduation Category Code" IN ('3','4') )
	OR (Cohort Facts."Year 1 Fall - Degree Pursued Level Code"='3'
	AND Cohort Facts."Year 4 Graduation Category Code" ='4' )
	THEN "Year 1 Fall - Headcount" ELSE 0 END) )
	/SUM("Year 1 Fall - Headcount")
	
5-Yr System Rate (%):
100*(SUM(CASE WHEN (Cohort Facts."Year 1 Fall - Degree Pursued Level Code"='2'
	AND Cohort Facts."Year 5 Graduation Category Code" IN ('3','4') )
	OR (Cohort Facts."Year 1 Fall - Degree Pursued Level Code"='3'
	AND Cohort Facts."Year 5 Graduation Category Code" ='4' )
	THEN "Year 1 Fall - Headcount" ELSE 0 END) )
	/SUM("Year 1 Fall - Headcount")

6-Yr System Rate (%):
100*(SUM(CASE WHEN (Cohort Facts."Year 1 Fall - Degree Pursued Level Code"='2'
	AND Cohort Facts."Year 6 Graduation Category Code" IN ('3','4') )
	OR (Cohort Facts."Year 1 Fall - Degree Pursued Level Code"='3'
	AND Cohort Facts."Year 6 Graduation Category Code" ='4' )
	THEN "Year 1 Fall - Headcount" ELSE 0 END) )
	/SUM("Year 1 Fall - Headcount")

X-Yr System Rate (%):
100*(SUM(CASE WHEN (Cohort Facts."Year 1 Fall - Degree Pursued Level Code"='2'
	AND Cohort Facts."Year X Graduation Category Code" IN ('3','4') )
	OR (Cohort Facts."Year 1 Fall - Degree Pursued Level Code"='3'
	AND Cohort Facts."Year X Graduation Category Code" ='4' )
	THEN "Year 1 Fall - Headcount" ELSE 0 END) )
	/SUM("Year 1 Fall - Headcount")

*****Version 2 Using Year X Outcome Category Code

3-Yr System Rate (%):
100*(SUM(CASE WHEN Cohort Facts."Year 3 Outcome Category Code" IN ('01','02')
	THEN "Year 1 Fall - Headcount" ELSE 0 END) )
	/SUM("Year 1 Fall - Headcount")

4-Yr System Rate (%):
100*(SUM(CASE WHEN Cohort Facts."Year 4 Outcome Category Code" IN ('01','02')
	THEN "Year 1 Fall - Headcount" ELSE 0 END) )
	/SUM("Year 1 Fall - Headcount")
	
5-Yr System Rate (%):
100*(SUM(CASE WHEN Cohort Facts."Year 5 Outcome Category Code" IN ('01','02')
	THEN "Year 1 Fall - Headcount" ELSE 0 END) )
	/SUM("Year 1 Fall - Headcount")
	
6-Yr System Rate (%):
100*(SUM(CASE WHEN Cohort Facts."Year 6 Outcome Category Code" IN ('01','02')
	THEN "Year 1 Fall - Headcount" ELSE 0 END) )
	/SUM("Year 1 Fall - Headcount")

X-Yr System Rate (%):
100*(SUM(CASE WHEN Cohort Facts."Year X Outcome Category Code" IN ('01','02')
	THEN "Year 1 Fall - Headcount" ELSE 0 END) )
	/SUM("Year 1 Fall - Headcount")