IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Sum Fields


IBM Mainframe Forums -> DFSORT/ICETOOL
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
ballaswaroop

New User


Joined: 20 Sep 2005
Posts: 25

PostPosted: Tue May 02, 2017 11:07 am
Reply with quote

Hi - I want to sum the following values

0001 USD 11,000.00
0002 GPP 222,000.12
0001 USD 111,111.23
0002 GPP 55.11

The value is in TTT,TTT.II format.
Back to top
View user's profile Send private message
Nic Clouston

Global Moderator


Joined: 10 May 2007
Posts: 2455
Location: Hampshire, UK

PostPosted: Tue May 02, 2017 3:39 pm
Reply with quote

What is the problem? You know what you want to do and you know the edit mask to use. You know there are similar problems postedand you know where to find the manual.

One thing youy apparently do not know - even after 12 years on the forum - is how to use the code tags to make the data look how you want.
Back to top
View user's profile Send private message
steve-myers

Active Member


Joined: 30 Nov 2013
Posts: 870
Location: The Universe

PostPosted: Tue May 02, 2017 5:10 pm
Reply with quote

The real problem here may be converting the USD amounts to GPP amounts so you're not adding apples and oranges, which usually doesn't work very well.
Back to top
View user's profile Send private message
RahulG31

Active User


Joined: 20 Dec 2014
Posts: 446
Location: USA

PostPosted: Tue May 02, 2017 8:38 pm
Reply with quote

ballaswaroop wrote:
Hi - I want to sum the following values

0001 USD 11,000.00
0002 GPP 222,000.12
0001 USD 111,111.23
0002 GPP 55.11

The value is in TTT,TTT.II format.

ballaswaroop,
This is as poor as your earlier posts on this forum. I took the pain of going through a couple of your earlier posts and it seems that you have been posting almost every year from 2005. It is really hard to believe that such an experienced 'programmer' doesn't even know how to ask a question.

Do you want the USD and GPP amounts to be added separately?

What is 'GPP' anyways? Do you mean 'GBP'? OR Is it something entirely different?

.
Back to top
View user's profile Send private message
Rohit Umarjikar

Global Moderator


Joined: 21 Sep 2010
Posts: 2588
Location: NYC,USA

PostPosted: Tue May 02, 2017 8:55 pm
Reply with quote

Quote:
Hi - I want to sum the following values
Whatever you want you can get by doing easy little research on this forum or Google and that is the easiest way you get close to your solution than waiting for someone to write a SORT card for you. Try and think how to twist this card to your need.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DFSORT/ICETOOL

 


Similar Topics
Topic Forum Replies
This topic is locked: you cannot edit posts or make replies. how to extract a portion (e.g. fields... SYNCSORT 8
No new posts Break a record into fields, each fiel... SYNCSORT 2
No new posts FIELDS OVERLAPPING WITH MODE = IN OR ... CICS 3
No new posts Sort on different fields, removing du... SYNCSORT 8
No new posts Please help - SORT with SUM fields an... DFSORT/ICETOOL 6
Search our Forums:

Back to Top