Need an Average, but it's counting NULLS as a zero

I need an average of the # of FT column.  Because of the schema, it's counting nulls, thus essentially cutting the average in "half".  I KNOW this can be fixed, I am just struggling.  Might be becaus...