#VALUE! error in a Pivot Table Calc Field

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.

Category:Office Views:0 Time:2013-02-12

Related post

Copyright (C) dskims.com, All Rights Reserved.

processed in 0.072 (s). 11 q(s)