Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
Sum Fields

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL
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    Post subject: Sum Fields
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: 1894
Location: UK

PostPosted: Tue May 02, 2017 3:39 pm    Post subject:
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: 574
Location: The Universe

PostPosted: Tue May 02, 2017 5:10 pm    Post subject:
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: 401
Location: USA

PostPosted: Tue May 02, 2017 8:38 pm    Post subject: Re: Sum Fields
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

Senior Member


Joined: 21 Sep 2010
Posts: 1806
Location: NY,USA

PostPosted: Tue May 02, 2017 8:55 pm    Post subject:
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    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Subtract the ZD fields to provide neg... Balaryan DFSORT/ICETOOL 4 Wed Oct 11, 2017 10:51 pm
No new posts Addition of two records on 2 fields amar143 SYNCSORT 8 Tue Oct 03, 2017 11:14 am
No new posts Split file based on comparsion to 2 f... Div Grad DFSORT/ICETOOL 3 Thu Jul 27, 2017 9:16 pm
No new posts How to write Specific Fields from Mul... Padhu SYNCSORT 6 Thu Jul 06, 2017 10:26 am
No new posts Validate date and numeric fields and ... Rick Silvers DFSORT/ICETOOL 6 Thu May 11, 2017 6:51 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us