Pivot Table Average Incorrect

[acmac1962]

Hi,
trying to get average to work in a pivot table but noticed it is displaying incorrectly

I Want the average to display for Frees For by Season / Games Played for Season

In the attached example

Year Pivot Value Value I want returned
2017 1.6 1.0
2018 1.3 0.7
2019 2.0 1.3

It looks like it is only dividing by cells that actually have a value in them - not zeroes (i.e. 2017 has 8 games but only 5 where frees for have values so 8 games / 5 = 1.6 but it should be 8games / 8 = 1.0
Looking online it looks like Calculated Field may be able to do this but I cant seem to get it to return the values I want above.

Appreciate any help anyone can provide.

Regards, Andrew

[rorya]

The simplest solution would be to actually have 0 rather than blank cells in your source table, if you can?