 |
MVSFORUMS.com A Community of and for MVS Professionals
|
FAQ
Search
Quick Manuals
Register
Profile
Log in to check your private messages
Log in
| Search found 4 matches |
| Author | Message |
|---|---|
 Topic: Sum positive and negative amounts separately |
|
| Telbont Replies: 11 Views: 10593 |
 Forum: Utilities Posted: Wed Feb 25, 2009 1:42 pm Subject: Sum positive and negative amounts separately |
| Thanks for the one step approach which works fine and is certainly more efficient than a 3 steps sort merge. Never knew much about the IFTHEN conditional keyword so a lot learnt on this topic. | |
| Topic: Sum positive and negative amounts separately |
|
| Telbont Replies: 11 Views: 10593 |
Forum: Utilities Posted: Thu Oct 16, 2008 9:15 am Subject: Sum positive and negative amounts separately |
| Thanks all for the responses and time spent. I used 3 steps as suggested by Dibakar and achieved the end result - 2 SORT INCLUDES and 1 MERGE step. | |
| Topic: Sum positive and negative amounts separately |
|
| Telbont Replies: 11 Views: 10593 |
Forum: Utilities Posted: Tue Oct 07, 2008 1:08 pm Subject: Sum positive and negative amounts separately |
| The output shown by edkir98 is exactly what I want except that the numeric field is defined as shown by kolusu so the sign is embedded on the last byte. Maybe I should try to include a bit field in th ... | |
| Topic: Sum positive and negative amounts separately |
|
| Telbont Replies: 11 Views: 10593 |
Forum: Utilities Posted: Wed Sep 24, 2008 3:52 pm Subject: Sum positive and negative amounts separately |
| Is it possible using SORT utility (have SYNCSORT) to sum same key field records based on sign of the sum field i.e. to sum positive and negative records separately for a given key? The sum field is a ... | |
All times are GMT - 5 Hours |