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
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