Is the division by hours in the underlying data or in the pivot table itself?

If it is in the underlying data then you need to change the calculated field
to an IF statement that include an ISERR statement to look for errors, e.g.:

IF(ISERR(calculation)=true,calculation,0)

So if ISNA sees and error it will return 0, otherwise it will return your
normal info and this will stop the errors in your pivot.

Hope this helps,

Nigel

"Rayo K" wrote:

Hello,

I have created a pivottable to summarize production data for a two shift 6
day/week operation. I want to summarize Week-to-date and Month-to-date. I set
up days as rows and shifts as columns. Days that have no data show up as
errors due to division (as in by 0 hours). The table calculates daily
subtotals, and subtotals for each shift, but for some reasons, it gives an
error for the grand totals. Any ideas?