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?
Bookmarks