Division Error

mkelly

Registered User.
Local time
Today, 16:25
Joined
Apr 10, 2002
Messages
213
I have a report that calculates the number of hours worked in a given time.

It also sums the weighted average per page.

I need to divide the hours worked by number of weighted pages to get an "average pages per hour"

However whenever I try to divide the two I always get an error message in my pages per hour box.

Any sugestions
All help appriciated
 

Attachments

Pat Hartman said:
You can't use a control with aggregate function elsewhere. You need to reproduce the function.

=Sum(HoursWorked) / WeightedPages


Thanks Pat as always you are a great help!
 

Users who are viewing this thread

Back
Top Bottom