ISERROR on GETPIVOTDATA
 

I have the following formula, but I need to factor in the ISERROR function as
well, but I'm not sure how to include it. It needs to go in just before the
2 GETPIVOTDATA functions but I've tried it and it doesn't seem to work for me.

Could someone just clarify how I should include them?

=IF($S30V$9,"",IF($H30="",GETPIVOTDATA("GWP exc. IPT",'Company
Pivot'!$A$5,"TransactionDate",MONTH(V$9),"BrokerCo mpanyId",$F30,"Group
Code","","Years",YEAR(V$9)),GETPIVOTDATA("GWP exc. IPT",'Company
Pivot'!$A$5,"TransactionDate",MONTH(V$9),"Group
Code",$H30,"Years",YEAR(V$9))))

Many thanks!

ISERROR on GETPIVOTDATA
 

Hi,

Try

=IF($S30V$9,"",IF($H30="",GETPIVOTDATA("GWP exc. IPT",'Company
Pivot'!$A$5,"TransactionDate",MONTH(V$9),"BrokerCo mpanyId",$F30,"Group
Code","","Years",YEAR(V$9)),IF(ISERR(GETPIVOTDATA( "GWP exc. IPT",'Company
Pivot'!$A$5,"TransactionDate",MONTH(V$9),"Group
Code",$H30,"Years",YEAR(V$9))),"",GETPIVOTDATA("GW P exc. IPT",'Company
Pivot'!$A$5,"TransactionDate",MONTH(V$9),"Group
Code",$H30,"Years",YEAR(V$9)))))

If you are using 2007 look at IFERROR instead.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Sarah (OGI)" wrote:

I have the following formula, but I need to factor in the ISERROR function as
well, but I'm not sure how to include it. It needs to go in just before the
2 GETPIVOTDATA functions but I've tried it and it doesn't seem to work for me.

Could someone just clarify how I should include them?

=IF($S30V$9,"",IF($H30="",GETPIVOTDATA("GWP exc. IPT",'Company
Pivot'!$A$5,"TransactionDate",MONTH(V$9),"BrokerCo mpanyId",$F30,"Group
Code","","Years",YEAR(V$9)),GETPIVOTDATA("GWP exc. IPT",'Company
Pivot'!$A$5,"TransactionDate",MONTH(V$9),"Group
Code",$H30,"Years",YEAR(V$9))))

Many thanks!