GetPivotData when value is blank

[cmajka]

Hi All -

I am trying to understand how to reference a cell that is blank in the GetPivotData function in a power pivot table. My formula looks like this:

=IFERROR(GETPIVOTDATA("[Measures].[Count of Policy]",Work_Pivots!$A$1666,"[APPEND_TABLE].[RenewalIndicator2]","[APPEND_TABLE].[RenewalIndicator2].&["&D$1&"]","[APPEND_TABLE].[Number_of_Families]","[APPEND_TABLE].[Number_of_Families].&["&$Z156&"]"),0)

where cell Z156 is actually blank. For some reason, this formula does not recognize it, and therefore, does not count the blank cells.

Any suggestions?

Thanks