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
The error comes up as C is sometimes 0
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
You are welcome. If my reply helped, please mark it as Answer.