MarkEOwen
asked on
Create a Running Total or Summary of Maximum Values in a group
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I am unable to use the summary fields so I have had to resort to using several SQL views to extract the data directly from the details
ASKER