Hello Everyone,

I am having trouble using the GETPIVOTDATA function to obtain data from
a pivot table containing the occurrence of monthly maintenance events
(fields of interest include month, location, whether the event is
severe? [a true / false or Y / N field], # of occurrences [can often be
zero, as sometimes events or severity is infrequent]).

The Pivot table appears okay (enabled reture zero option), but
GETPIVOTDATA yields a #REF error in years where occurrences are
infrequent from December to an earlier month in the year. The table or
GETPIVOTDATA function appears to be outsmarting itself, as these zeros
are real data). When I construct a GETPIVOTDATA function, not including
the check for severity - TRUE / FALSE or Yes / No check, it will return
yield data, but this check yields the error when data is not observed
in the entire pivot table from December of to an earlier month in any
particular year.

I have read about work arounds that include the:

=IF(ISERROR(your_formula),"0",your_formula)

formula to work around this, but this seems so clunky and may hide
other errors.

Any advice? Thanks Randall.