Please refer to this thread for a possible answer:
As for your second question, you'd have to distinguish
between the zero sales (the evidence of absence of sales)
and the null sales (the absence of evidence of sales).
Hope it could help a bit.
May I ask why you don't want to use a window calculation for figuring out the moving average? That's the most direct way of doing it. I'm not sure how to do it otherwise.