does it change when you not use single quotes in '2006' and just 2006. The expression should work.
The only possible explanation i can think of which may forced you to think its not working is if all the months have same number of sales and the average will always be same. and you are assuming that the numerator will not change so that may be the case. but that is highly unlikely