• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Workaround to avoid #REF! error when summing two dynamic pivot tables and one of the tables = $0.00

Y

Yodelayheewho

Member
I understand GETPIVOTDATA throws a #REF error if the data it is referencing isn't showing. This happens at the end of each month because shipments move from Pivot 1 and Pivot 3 (Proposed Shipments by Month) to Pivot 2 and Pivot 4 (Current Month Shipments Complete).

The IFERROR worked for 3 of the 5 cells circled in the image below. So they 'look' correct. However, the summing of the grand totals is not recognizing them as $0.00 and throwing the error.

If anyone has a creative solution, I would appreciate it.

1688391581295.png
 
Why don't you just add up the cells that already have the IFERROR applied, rather than using the same GETPIVOTDATA formulas again?
 
I got rid of GETPIVOTDATA got the two totals and grand total and used SUM instead. It works perfectly. So simple. Thank you Debaser!
 
You must log in or register to reply here.
Back
Top