Link to home
Start Free TrialLog in
Avatar of MarkEOwen
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
Avatar of bdreed35
bdreed35
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of MarkEOwen
MarkEOwen

ASKER

I have tried the RT field in both footers on groups 2 and 3 and the max value is displayed, not a summary. Unfortunately, I don't have access to the underlying detail for the summary field ContractRevisedValue.
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