I am trying to use the getpivot data for an interactive spreadsheet. Some of
the getpivotdata functions that I am creating do not exist yet so I am
getting an error. (it is a live worksheet that gets modified daily). I
figured if I can create an IF statement to verify for numerical data, then
maybe I can bypass that error. Is there a way to check for numerical data.
This is what I am writing IF(getpivotdata(@#$%)=0 [this is where I would
want my numerical check], getpivotdata(@#$%), 0). Basically I want to
process a check to see if the getpivot data is a number. If it is not, then
I am assuming that it is an error and therefore the if statement would place
a 0. Is there any way to do this. I know I should be using ACCESS but we
don't have that available and I am trying everything I can with excel.

Thanks

Omar

You may use the functions ISERROR, or ISNA, instead of a numeric calculation.
=IF(ISERROR(GETPIVOTDATA(@#$%)),0,GETPIVOTDATA(@#$ %))

Hope this helps,
Miguel.

"Omar" wrote:

I am trying to use the getpivot data for an interactive spreadsheet. Some of
the getpivotdata functions that I am creating do not exist yet so I am
getting an error. (it is a live worksheet that gets modified daily). I
figured if I can create an IF statement to verify for numerical data, then
maybe I can bypass that error. Is there a way to check for numerical data.
This is what I am writing IF(getpivotdata(@#$%)=0 [this is where I would
want my numerical check], getpivotdata(@#$%), 0). Basically I want to
process a check to see if the getpivot data is a number. If it is not, then
I am assuming that it is an error and therefore the if statement would place
a 0. Is there any way to do this. I know I should be using ACCESS but we
don't have that available and I am trying everything I can with excel.

Thanks

Omar