Feb 03 2021 12:29 PM
I need a suggestion on how to use IFERROR with this formula
=GETPIVOTDATA("Net Cost",'2021 Pivot Tables'!$A$162,"Specialty","EL")
where EL does not currently appear in the pivot but may in the future.
I can't seem to get the FALSE statement placed in the correct spot or with nesting.
Feb 03 2021 12:37 PM
How about
=IFERROR(GETPIVOTDATA("Net Cost",'2021 Pivot Tables'!$A$162,"Specialty","EL"),"")
or
=IFERROR(GETPIVOTDATA("Net Cost",'2021 Pivot Tables'!$A$162,"Specialty","EL"),"-not available-")
Feb 03 2021 01:12 PM
Thank you! That worked fine.
I thought I had already tried that because that would have been the simplest. Sometimes I overcomplicate the formula.