Pivot Table

[ericbabel]

Hello, here is a couple formulas I was given that need some tweaking...
=GETPIVOTDATA("File#",$A$3,"Owner","Andrew Barnes","Equipment","FCL")
=GETPIVOTDATA("File#",$A$3,"Owner","Andrew Barnes","Equipment","LCL")

Problem is that sometimes there might not be an "LCL" and I need 0 to populate so that I can use it in my SUM formula in another spot on the table. The same is true for "FCL". I need 0 to populate when there is not an "FCL" listed in the table.

If more information is needed to help with the solution let me know and I can send the file I am working with. Thanks for any and all help.

 

[DonkeyOte]

XL2007+

=IFERROR(GETPIVOTDATA("File#",$A$3,"Owner","Andrew Barnes","Equipment","FCL"),0)

Prior to XL2007

=LOOKUP(9.99E+307,CHOOSE({1,2},0,GETPIVOTDATA("File#",$A$3,"Owner","Andrew Barnes","Equipment","FCL")))

 

[ericbabel]

It looks liek this...

=IFERROR(GETPIVOTDATA("File#",$A$3,"Owner","Andrew Barnes","Equipment","FCL"),0)</PRE>helped. The formula is producing the desired resluts. I thank you very much four your time.