Hello - I have searched through the discussions, but have not come across anything yet to help me out. I have a database that I use to record evaluations for projects. Each project has a weighted score based on multiple evaluation criteria. I have two table occurrences with a relationship between the project and the criteria. I have been able to calculate the average for each criteria (= Average (TO2::Weighted_Value), but not the additive value of those averages (= Sum (TO2::Avg). The sum calculation returns the sum of the average from all evaluators. I also have two sub summary parts set up for Projects and Criteria. What I need is for a total of the Criteria averages for the project. So, from the table below P1 Tot = 23.9; P2 = 75.9; p3 = 99. Any assistance on this issue would be greatly appreciated!

Project | Reviewer | Criteria | Weighted_Value | Avg | Tot |

P1 | R1 | C1 | 13.2 | 6.6 | 13.2 |

P1 | R2 | C1 | 0 | 6.6 | 13.2 |

P1 | R1 | C2 | 33 | 17.325 | 34.65 |

P1 | R2 | C2 | 1.65 | 17.325 | 34.65 |

P2 | R1 | C1 | 9.9 | 19.8 | 39.6 |

P2 | R2 | C1 | 29.7 | 19.8 | 39.6 |

P2 | R1 | C2 | 29.7 | 23.1 | 46.2 |

P2 | R2 | C2 | 16.5 | 23.1 | 46.2 |

P2 | R2 | C3 | 33 | 33 | 66 |

P2 | R1 | C3 | 33 | 33 | 66 |

P3 | R3 | C1 | 33 | 33 | 165 |

P3 | R4 | C1 | 33 | 33 | 165 |

P3 | R5 | C1 | 33 | 33 | 165 |

P3 | R7 | C1 | 33 | 33 | 165 |

P3 | R6 | C1 | 33 | 33 | 165 |

P3 | R3 | C2 | 33 | 33 | 165 |

P3 | R4 | C2 | 33 | 33 | 165 |

P3 | R5 | C2 | 33 | 33 | 165 |

P3 | R7 | C2 | 33 | 33 | 165 |

P3 | R6 | C2 | 33 | 33 | 165 |

P3 | R3 | C3 | 33 | 33 | 165 |

P3 | R4 | C3 | 33 | 33 | 165 |

P3 | R5 | C3 | 33 | 33 | 165 |

P3 | R7 | C3 | 33 | 33 | 165 |

P3 | R6 | C3 | 33 | 33 | 165 |

Sum ( TO2::Avg ) should give you what you are looking for if you write the calculation in the project Table or I don't understand the question.