I'm trying to build something to calculate forecast and below is what I have. The problem is when we release a product in the middle of the year, I don't want to average in all of the "0" months. How can I do something similar to the expression below but only average out months with >1 sales?
Code:
Average Month: ([Forecast]![Jan]+[Forecast]![Feb]+[Forecast]![Mar]+[Forecast]![Apr]+[Forecast]![May]+[Forecast]![June]+[Forecast]![July]+[Forecast]![Aug]+(([Forecast]![Sept]+[Forecast]![Oct]+[Forecast]![Nov]+[Forecast]![Dec])*1.25))/12