How to get rid of #Div/0 in pivot table

[BusyAccountant]

I have got a calculated field in a pivot table, the formula doesn't accept the if(iserror(.......) command. Is there a way to handle this type of error in a pivot table?

 

[Mudface]

Click to the pivot table Options menu and check the 'For error values, show:' box, leaving it blank if you don't want to display anything.

 

[BusyAccountant]

Thanks for that.

 

[Dosaparks]

Not sure if this comment will ever be read but I just came across this over 10 years later and found it also of great assistance.

So powerful this forum. Thanks all to those who contribute and make it so.

 

[gornalgremlin]

Not sure if this comment will ever be read but I just came across this over 10 years later and found it also of great assistance.

So powerful this forum. Thanks all to those who contribute and make it so.

A bit late but, yes I did read it and it is still relevant 15 years on!
by my calculations, the next reply is due in 2020!

 

[Cynicmonster]

A bit late but, yes I did read it and it is still relevant 15 years on!
by my calculations, the next reply is due in 2020!

Sorry to disappoint you This has been driving me nuts for ages. Thanks for the help.

 

[TexAndTheCities]

This has been driving me insane for years-THANK YOU!!!

 

[blevak]

This doesn't appear to work when I use the AVG function in the pivot table. Any suggestions?

 

[StupidOldDuffer]

A bit late but, yes I did read it and it is still relevant 15 years on!
by my calculations, the next reply is due in 2020!

It is now 2020 and I have just used this tip, very successfully (albeit on Excel 2011). Roll on 2030!

 

[redshifted]

October 2024, my pivot table problem has been solved thanks to the original post 21 years ago! I created an account here just to keep this post rolling. lol
Thank you Mudface!