Formulas within pivot tables

[Guest]

I currently have a pivot table which how many items I need to produce through
a certain machine in a given week (this is in the data area).

I have now added the qty/hr into the row field. I have tried to add a
formula to divide the data by qty/hr but have been getting incorrect results.
I have now establised how it is calculating these result but want to now how
to correct it.

Here is an example:

There are 247 pieces to produce and the qty/hr is 33 therefore the result
should be 7.48hrs. Using the formula above the pivot table is giving a
result of 1.87hrs, there reason for this is that the qty of 247 is the total
of 4 different jobs, so for some reason it is dividing the 7.48 by 4, which
is not what I want.

Is there anyway of changing this.

Thanks

 

[Mike Fogleman]

It sounds like your formula is using the CountOf Jobs (4) instead of the
SumOf JobPieces (247). Without seeing your table it is difficult to
speculate where or how to correct. If you don't have a data column with
total JobPieces, perhaps you need to add it so your formula can refer to it
directly.
Mike F