this works fine but if I want to do the same for FiscalYear=2012..
But I want it to add the first two months of our fiscal year (November and December) and then also add the next 10months of sales forecast so that we can see how the year will look.
Is there a way for me to tell the above formula to add the Actual Sales and then add the forecast which would be something like >Month(now())+1 (i think this will give January onwards...