Hi I am using IFERROR in a Calc Filed on a Pivot table. However I get #VALUE! errors

The formula works ok on a spread sheet, it is just when I add it to the Calc Field that the error comes up

=iferror(A/((B/5)*C),"")

The error comes up as C is sometimes 0

-------------Problems Reply------------

Hi,

In the Calculated Field formula, enter the formula without the IFERROR() function. To suppress errors in the Pivot Table, right click on any cell > Pivot Table Options and check the box for "For error values show" > OK

Hope this helps.

Thank you, works a treat

Hi,

You are welcome. If my reply helped, please mark it as Answer.