Pivot app - and Count function
I've created a pivot table to summarize the number of task completions in a month. From this, I want to calculate the average monthly completions.
The problem is, the table does not put a '0' in the months with no completions, so the averages are not calculated correctly (see below - 1 isn't the monthly average when only 1 was completed that year).
Maybe the answer is 'just add the zero' - but isn't 0 a real count?
When I formatted my pivot table and just used the sum function for the child rows - you can see it isn't counting blanks as months.
I tried changing my formula on the source sheet that is wrapped in an IFERROR to force blanks - changed it to force "0" - but that isn't it.
As a workaround, I've made automations to change blank cells to 0, but I'm thinking that 0 should just be a number that is automatically input on the pivot table.
I wanted to check in with the SmartSheet community to see if I'm missing something.