# Report / Calculation Help

**mikethecreative**Jan 2, 2014 3:56 PM

### 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