If you have to SORT the data, why do you show sample data which is in sequence? Since the data is obviously not of a type of ZD, can you find in your documentation a type which would describe your data and which you can use in SUM?
Bill, Only first few records are sorted not all. I am able to sum the scores (numeric column) but not revenue, since revenue has decimal point. Please advise.
You're going to have to use INREC (I assume you've consulted your documentation and found no useful data-type for SUM) to turn your character-number into a ZD. Since it seems that your data is all at fixed positions, temporarily extend the record with the data at 31,10 and 42,2 (ie ignoring the decimal-point) and SUM on that field. In OUTREC, use BUILD to relocate the summed value to its correct position (leaving the decimal-point unchanged), and return the record to its original size.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
FAQ
Search
Quick Manuals
Register
Profile
Log in to check your private messages
Log in
