ACCT NO DATE AMOUNT
324167453 11/04/2006 $6,603,039.84
125347918 11/04/2006 $7,145.02-
820014986 11/03/2006 $23,498,219.41
I want to Sum up the Amount field Based on the Date. The length of the
Amount field is 15 Bytes from Column 56 To 70 and the 70th Column is Signed Bit. It may be spaces or it may have a Minus Symbol, based the Value.
Here's a DFSORT job that will do what you asked for. I didn't know where you wanted the negative sign for the output records, so I assumed you wanted it before the number. If not, change the EDIT and SIGNS values as needed.