Average Formula to Exclude blank or zero values

In this case the best approach is difficult to say as we don’t know all the details. Like where is this calculation used. Is it on a template, in a normal or virtual column, with the initial value etc. This matters as well.