Forum Discussion
QuickBaseCoachD
11 years agoQrew Captain
Try creating a real field and not a calculated field on the report, to do your calculation, and set its field properties to show averages and not totals. Note that this would be an average of averages which may not be mathematically correct, but may be good enough for your needs. If you need true averages, then i would need to better understand the specific calculation you need to do and there may be a requirement to set up additional tables to enable bucketing by day or by wee or by month, by person.