To solve the problem of not being able to use an IF statement in a calculated field I used the pivot table options to make errors return N/A instead of #DIV. Now my grand total line for this field which is a percentage returns the same N/A.

I have fields A, B, and C.

Calculated field is C/B in which B is sometimes 0.

In essence the grand total line for the calculated item should still equal grand total of column C/B but it returns the N/A as stated.

Any suggestions?