Redlands Unified School District

Percent Absent: XX = school code

LIST STU AHS STU.ID STU.NM AHS.EN AHS.AB (( CAST(AHS.AB/CAST(AHS.EN AS DEC(10,2) )*100 AS DEC(10,2) ) )) IF AHS.EN # 0 AND AHS.YR = "2017-2018" AND AHS.SCL = XX

Percent Present:

LIST STU AHS STU.ID STU.NM AHS.EN AHS.AB (( 100 - ( CAST(AHS.AB/CAST(AHS.EN AS DEC(10,2) )*100 AS DEC(10,2) ) ) )) IF AHS.EN # 0 AND AHS.YR = "2017-2018" AND AHS.SCL = XX

Thank you Youa Lee from Merced City School District

Using it in a Larger Query

This query looks at al athletes who are enrolled in a Period 9 class.

LIST STU SEC MST CRS AHS STU.LN STU.FN MST.PD CRS.DE (( 100 - ( CAST(AHS.AB/CAST(AHS.EN AS DEC(10,2) )*100 AS DEC(10,2) ) ) )) IF AHS.EN # 0 AND AHS.YR = "2018-2019" AND MST.PD = 9