Summary Issue: Script

[monkeybones]

I am running into a problem trying to get an average productivity per employee report to calculate. What I have is employees clocking in and out in Filemaker which creates a new record for each entry. Then I have production information being entered independently which is also a new record for each occurance. I am currently able to run a report that summarizes the hours and qty produced by employee number. What I haven't been able to do is to get Filemaker to calculate the average productivity by employee. I tried created a cacluation field using the summary qty / summary hours fields but all that does is give me the overall total of the report and it doesn't break it down by employee.

 

Hopefully this is something that someone here can help me fix. If I didn't explain this well enough please let me know and I can pass on more info. Thank you in advance for any help.

[Databasic]

Hello Monkeybones

 

You probably need to use the GetSummary function ie:

GetSummary( Summaryfield;Breakfield)/GetSummary(Summaryfield;Breakfield) where the breakfield is the field on which the data is sorted - in your case Iguess its the employee number.

 

something like - Getsummary(SummaryQty;EmployeeNumberfield)/GetSummary(Summaryhrs;EmployeeNumberfield). - but it only works if the data is sorted by employee number field .

 

Cheers

[monkeybones]

Hello Monkeybones

 

You probably need to use the GetSummary function ie:

GetSummary( Summaryfield;Breakfield)/GetSummary(Summaryfield;Breakfield) where the breakfield is the field on which the data is sorted - in your case Iguess its the employee number.

 

something like - Getsummary(SummaryQty;EmployeeNumberfield)/GetSummary(Summaryhrs;EmployeeNumberfield). - but it only works if the data is sorted by employee number field .

 

Cheers

 

Thanks. I'll give that a shot.

[monkeybones]

Thanks. I'll give that a shot.

 

That worked perfect. Thank you for the help.