SUM using DFSORT

ballaswaroop · New User Joined: 20 Sep 2005 Posts: 25

Hi - I've the following file in the following format, I want to add my amount when ever there is change the number. Number starting from 45 length 18 chars and amount starting from 75 length 8.

Bill Woodger · Posted: Tue Mar 08, 2016 5:08 pm

And what problem are you having? From your sample data, your file is in sequence already, so how are you thinking of using SUM?

You need to temporarily extend your records in INREC to contain a numeric representation of your value, and then use OUTFIL reporting featuers, REMOVECC, NODETAIL, and SECTIONS (for your key) with TRAILER3 using TOT/TOTAL.

You seem to have a regular number of decimal places, so you just need a data-format which will remove the non-numeric characters for you, converting to PD, for instance.

For your output, it looks like you'll need an EDIT, as you'll want the commas and actual decimal-points.

Nic Clouston · Posted: Tue Mar 08, 2016 8:31 pm

Thse commas in the thousands look a bit funny - shouldn't 1,2200.02 be 12,200.02 etc?
And where do you want these totals - on change of key or at the end or as running totals on each record?

kranthikumarb · Posted: Wed Mar 09, 2016 12:15 pm

Ballaswaroop,

Do you want detail records along with individual trailers when key changes or only trailers are needed? Please provide sample output. That would help.