Variable ??

[lstieg]

Not sure posting in right area.... apologize if not.

Have a rpt that returns the following...

Company File # Acct # TT Desc Pl $ System
John Hopkins JH05162011 106217 P Success 94.71 CHA-FAC
John Hopkins JH05152011 106217 P Success 40.28 CHA-FAC
John Hopkins JH05142011 106217 T Success 15.89 CHA-FAC
John Hopkins JH05132011 106374 P Success 76.97 CHA-FAC
John Hopkins JH05122011 106463 T Success 50.00 CHA-FAC

There is a section break on company.... what I want to be able to do is create a variable or something that will sum the Pl $ if the TT is the same at the Acct # level... so from the above I would want to see the following... it sums the first 2 P records because the account number is the same.

John Hopkins JH05162011 106217 P Success 134.99 CHA-FAC
John Hopkins JH05142011 106217 T Success 15.89 CHA-FAC
John Hopkins JH05132011 106374 P Success 76.97 CHA-FAC
John Hopkins JH05122011 106463 T Success 50.00 CHA-FAC

Any help would be greatly appreciated.

 

[SkipVought]

hi,

John Hopkins JH05162011

has only ONE row in your example

What you want is a sum using these columns...
[tt]
Company Acct # TT Desc System
[/tt]
excluding File #

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]