I have created a simple logging application, where I log the number of successful events and the time taken.

In a form field I store the number of events (Number)

In a form field I store the time in hours (Decimal)

In a calculated Form field I store Events / Hour – giving the Events per hour for each record

In a Pivot report I then sum all of the records (Filtered list), it all works well except calculating the total events per hour for the report. Am I able to calculate the total average? (Sum of time / Sum of hours)

Any idea’s?