Create a Running Total or Summary of Maximum Values in a group
Posted on 2004-08-19
I need to sum a set of Maximum Values for a field named ContractRevisedValue. I have 3 levels of grouping. First by Project Name, Second by a formula field which takes the Left 2 characters from a field named BudgetCode and third by ContractNumber. The field ContractRevisedValue is actually a summary field within the Contract Invoice. A contract can have multiple invoices associated with it. Therefore, the ContractRevisedValue can have multiple values. Since I am looking for the most current value, I take the Max of the value and throw that into the Group 3 Header along with the Contract Number. I have tried to create a Running Total Summary field but am probably not choosing the appropriate change criteria in the Edit Running Total Field dialog box. The goal is to have a summary of the maximum values at the second grouping. In regular terms, I would like to know the sum of Maximum Contract Values for Each change in Budget Code.