# Report / Calculation Help

Question asked by mikethecreative on Jan 2, 2014
Latest reply on Jan 11, 2014 by philmodjunk

### Title

Report / Calculation Help

### Post

I need help creating a calculation or report. I've tried a few different things but nothing has worked.

Example:

Station 1 | 2003 - 2013

Month                     Average of Field #1                     Average of Field #2
1                     1.94                     5.02
2                     3.33                     5.63
3                     4.26                     2.01
4                     6.52                     4.18
5                     7.73                     0.564
6                     8.99                     0.0458
7                     8.26                     0.0391
8                     6.26                     0.28
9                     3.82                     2.228
10                     1.89                     3.533
11                     1.15                     8.14
12                     1.59                     4.17

I have data entered for each month for the last ten years in Field #1 and Field #2. The above table shows the Average of the past ten years for Field #1 and Field #2 (these Averages are Summary fields).

Problem:

I want to create a few calculations off of this data.

Example Calculation:

"Spring" = Sum ( Average of Data #1 ( Months 3-5 ) - .25 * Average of Data #2 ( Months 3-5 ) ) / Rate * 60

Then I want to create the same thing for Summer, Fall, Winter:

"Summer" = Sum ( Average of Data #1 ( Months 6-8 ) - .25 * Average of Data #2 ( Months 6-8 ) ) / Rate * 60

and so on.......