Hey guys,
I have a Pivot Table for a report that is updated daily when new data is uploaded to my company's intranet website. I want to have a running total for the month thusfar. To do this, I'm using GETPIVOTDATA to return the sum of values in a given date range. This way, I can just refresh the Pivot Table daily, and all the new numbers populate.
This formula looks like this:
\1
Right now, it works because I have the data for the whole range of dates I'm referencing in the Pivot Table (almost all of May).
For June, it returns a REF error because those dates currently do not have data.
\1
How can I have Excel ignore the #REF errors and calculate the sum normally? This will help me calculate a running total for the current month and make everything much easier for me (it'll make these reports a simple refresh).
Thanks for any help, I appreciate it.
Bookmarks