Reference Line Averages - HELP

Hi everyone,

I am trying to display an average on a bar chart, using the “mean” function within the reference line. The problem i have is that is counting £0.00 as null and this not displaying the true average. Any help would be appreciated.