1 Reply Latest reply on Aug 1, 2014 9:32 AM by philmodjunk

# How to Calculate Pieces per hour from 2 summary fields

### Title

How to Calculate Pieces per hour from 2 summary fields

### Post

I have 2 Summary fields Total Time and Total End Count. When i do my search for a certain job, user, and machine, I get the results in a form with the 2 summary fields at the bottom showing respective totals.That all works. My problem is how do i divide the Total end count field and the Total time field to show pieces per hour?

• ###### 1. Re: How to Calculate Pieces per hour from 2 summary fields

Define a calculation field and divide the Total End count by the Total Time but with time converted into hours. (Time fields store time as the number of seconds since midnight)

Total End Count / ( Total Time / 3600 ) // there are 3600 seconds in an hour

Using some math skills, you can rearrange the terms to use this expression:

Total End Count * 3600 / Total Time

This calculation will return "grand totals" based on your current found set. If you need to compute a sub total type value for use in a sub summary layout part, use the GetSummary function to get the two subtotals from your two summary fields.