5 Replies Latest reply on Mar 26, 2012 1:25 PM by Alex Kerin

    Summer /Winter Table calculation

      I want to add two columns to the end of my data named "Summer" and "Winter" where the avg of these months are calculated. The summer calculation is fairly easy its just the avg of months April-Sept. But the Winter calculation is October-March So for 2006 its the Oct-Dec of 06 and Jan-Mar of 07. I would like the winter 06 avg to include the 07 data. What's the best way to do this calculation?