AnsweredAssumed Answered

Averaging a week of less than seven days

Question asked by symbister on Dec 19, 2012
Latest reply on Dec 19, 2012 by symbister


Averaging a week of less than seven days


Hi - using Mac OS 10.6.8, FMP 11 We run a public gallery space and collect attendance data for each open day - Tuesday to Sunday, so I've setup a short routine to populate field 'myweek' to offset the built-in FM WeekOfYear, to begin counting from the first Monday of the year. We do however also have other activities on Mondays, so the report needs to summarise every week, and provide an average of the week's gallery attendances (screen shot) The Grand Summary totals attendances for any given period, with a script to only count DaysNotMondays into the overall average, but each week incorrectly averages attendance over seven days. I'd like to get each week to average by the actual number of days open, but unsure how to go about it. Somehow to count the days that have data in the attendance field, on a week-by-week basis, then use this number to average the days attendances. (In example shown, week ending 26 Feb should show average of 290) would appreciate any assistance