Howtos‎ > ‎PowerSchool‎ > ‎

Attendance Totals by Month

1. Go to System Reports -> sqlReports 4 tab -> expand the "Attendance" section.
2. Click "Attendance and Absence Rates by Date", then "Submit."
3. When the results display, click "CSV" to download them as a CSV and open that in Excel.
4. Insert a new row after the last day of September. 
5. In that new blank row's column C, type =SUM( and then drag to select the cells above (all the daily totals) and hit return to complete the formula.

Repeat for the other months. Example attached here with September and October completed.
Marion Bates,
Jun 16, 2016, 6:47 AM