3 Replies Latest reply on May 20, 2013 9:51 AM by Shawn Wallwork

    Calculated field-Average incidents per day

    Lisa Lacroix

      I work at a school district and am trying to calculate the average number of behavior events per day by month.  I have an incident date and an incident ID. What I can't figure out is how to calculate the average number of incidents per day by month BASED ON the number of school days in that month. I have attached a sample workbook.  For August, there were 13 school days and for September, there were 19 school days.  How can I get the average number per day? Thanks!