Power Pivot Table - Outside calculations

[AshleyH7]

Hello,

I have a power pivot table I am using to summarize some data. I am using it as a daily report and outside the pivot table I pull out and summarize specific data related to individual departments.

Two of the Lines I want to combine the total units produced. Which works fine, when both lines are run on both shifts. However, when the line is not run, it returns a REF error, as the data I am requesting it to SUM is not available.

Is there a way, or formula to eliminate the REF error, like a if this field exists add it to the others, if it doesn't then just add the others??


Thanks in advanced.

 

[RoryA]

Wrap it in IFERROR. For example:

=IFERROR(GETPIVOTDATA(...),0)+IFERROR(GETPIVOTDATA(...),0)

 

[AshleyH7]

Wrap it in IFERROR. For example:

=IFERROR(GETPIVOTDATA(...),0)+IFERROR(GETPIVOTDATA(...),0)

You are AMAZING and my new favorite person. I do not believe I didn't think of that!

Thank you so much!!!

 

[RoryA]

Glad we could help.