How to sum amounts in Edited format using sort?

arnab · New User Joined: 13 Mar 2006 Posts: 59 Location: UK

Hi All,

My requirement is to add all amounts based on some sort fields. I can very well do it using SUM fields but the problem is that the amounts are in Edited format (not ZD or BI or PD). For eg... 233.30-

How to add these amounts ?? Is here a way to convert characters to ZD or PD?

Frank Yaeger · Posted: Mon Dec 04, 2006 9:55 pm

You can use DFSORT's SFF format to convert those types of values to ZD or PD. You can do that with an INREC statement and SUM the ZD or PD values. Alternatively, you can use SFF directly with the TOT parameter of OUTFIL TRAILERx.

For more information on DFSORT's SFF format, see:

Use [URL] BBCode for External Links

If you want more specific help on this, show an example of your input records and what you want for the output records, and give the starting position and length of the fields you want to convert.