Monday, October 10, 2016

Absence Percentage by Date (Cur School) (SQL)

The Absence Percentage by Date (Cur School) reports absence percent for a school on a given date. The following calculation is used to determine the absence percentage: (Absences) / Enrollment x 100. Found at Start Page --> System Reports --> sqlReports 4 --> Attendance --> Absence Percentage by Date (Cur School) (here)




Code:
Here

1 comment:

  1. Great Report!!! Thank you for sharing. If you would to add the day of the week the rpeort add the following ( to_char(t1.cd,'DAY')

    ReplyDelete