Pivot Table #DIV/0 error in field summary Column but not in lower level.

Question

Hello,

I am having issues with my pivot table #DIV/0 populating on my weekly summary, but it is not an issue on my daily summary. What would be some possible causes of this and how can I correct it?

Answer 1

Hi @Isaac

Thanks for your sharing.

Based on my research, The Grand Total cells for 'WK37 Total' column which is for Grand Total cells for rows, have different calculation modes with Grand Total cells for other daily fields, that if there is any #DIV/0! error in 'WK37 Total' column cells, this error will occurs.

It seems to be by design.

If you can change the meaning of #DIV/0! in 'WK37 Total' column cell, please select a cell within a pivot table >
Right-Click and select Pivot Table Options > Tick "For error values Show" chechkbox, if you wanna errors to be number 0 > OK.

Or you can modify the cacluated field formula, such as for Profit Loss per Pound: =IF(ISERROR('Profit Loss'/'MFG Labor LBS'),0,'Profit Loss'/'MFG Labor LBS').

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

---