Return blank cell instead of zero using GETPIVOTDATA (Excel for Mac 2011)

[elandrajo]

Trying to use ISERROR and "" (see formula below) to return blanks instead of zeros for a table that holds sales data for the calendar year -- need values for months that have no sales data to register as blanks instead of zeros to ensure accuracy of charts that are based on table.

Am using Excel for Mac 2011.

=IF(ISERROR(GETPIVOTDATA("Sum of Total Price (converted)",$1:$1048576,"Sales Operations Location","US","Close Month","5/1/12")),"",GETPIVOTDATA("Sum of Total Price (converted)",$1:$1048576,"Sales Operations Location","US","Close Month","5/1/12"))


Any help that can be provided is much appreciated!

[Admin]

Hi elandrajo,

Welcome to Excel Fox !!!

A guess,

=IFERROR(IF(GETPIVOTDATA("Sum of Total Price (converted)",$1:$1048576,"Sales Operations Location","US","Close Month","5/1/12")=0,"",GETPIVOTDATA("Sum of Total Price (converted)",$1:$1048576,"Sales Operations Location","US","Close Month","5/1/12")),"")