Hi All,

I am new to this site, so hello all.

I have recently learnt a lot more about excel, mostly via YouTube etc. I am building a semi automated reporting dashboard for my company, this is 95% complete but i have a few basis errors that maybe someone could help me solve?

I have a weekly data dash that gets data from a pivot table, this works ok but when a week has no values inputted, e.g no complaints for Week 52 due to Christmas for example i get an error as we have nothing to reference. I have overcome this by the below formula:
=IFERROR(GETPIVOTDATA("ID",'Customer Complaints - Weekly'!$A$6,"Week Number","52"),"0")
This works well, but i then also want to do a 13 weeks rolling average and this causes issues. I am using this as the 13 Week RA Formula:
=IFERROR(AVERAGE(D6:P6),"")
But when it sees a 0 from the Get Pivot formula it doesn't count this in the average as it does not see it a number. So i could have the below numbers
Week 40 = 1
Week 41 = 2
Week 42 = 2
Week 43 = 2
Week 44 = 0
Week 45 = 0
Week 46 = 2
Week 47 = 2
Week 48 = 1
Week 49 = 3
Week 50 = 0
Week 51 = 1
Week 52 = 0

The formula will return an average 1.78 (16/9) of but it should be 1.23 (16/13)

Any help would be appreciated.

Regards