New Member
January 11, 2018
Many thanks.
Power Query
Power Pivot
Xtreme Pivot Tables
Excel for Decision Making
Excel for Finance
Excel Analysis Toolpak
Power BI
Excel
Word
Outlook
Excel Expert
Excel Customer Service
November 8, 2013
Hi Olayinka,
Welcome to our forum!
Are you referring to the error from Dashboard sheet cell D6- =GETPIVOTDATA("Sum of No of Active Users (Visits)",'EShop Headline Pivots'!$A$3) ?
The error comes from your Raw data, rows 96-100 are empty, you have to remove them and press Refresh All.
In those calculated columns, never use such formulas without error check:
(F2-G2)/G2
If G2 is empty, you will receive DIV/0! error, so you have to check first if G2 is <>0, or use IFERROR:
=IF(G2<>0,(F2-G2)/G2,0)
Or:
=IFERROR((F2-G2)/G2,0)
An error will break the calculation chain, all subsequent formulas will display the same error.
Answers Post
New Member
January 11, 2018
Thanks so much for the correction & added advise provided above.
Yes, I was referring to the Dashboard sheet and the two EShop Headline Pivots sheet (cell 73 & 74 respectively) which have added blank spaces.
I'm thinking the errors affected the dates on the pivot charts in the Dashboard sheet, but I may be wrong too.
[[[[Note to Self: I'm taking that I should now always insert the IFERROR FORMULA to avoid any such re-occurrence.]]]] 😀
1 Guest(s)