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: 2092
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: 664
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: 442
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: 2016
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
This topic is locked: you cannot edit posts or make replies. remove the gap b/w 2 fields shymala COBOL Programming 5 Thu Aug 02, 2018 12:05 pm
No new posts Comparing Comp-3 fields with greater ... Prateeksichem1 DFSORT/ICETOOL 11 Fri Jul 13, 2018 8:45 am
No new posts KSDS file fields update by passing va... Anil Kumar Prajapati TSO/ISPF 5 Wed Jul 11, 2018 5:59 am
No new posts Sort numeric fields with trailing spaces sancraig16 SYNCSORT 7 Tue Apr 03, 2018 1:21 am
No new posts SORT 3 files,extract specific fields ... Kiransr DFSORT/ICETOOL 13 Fri Mar 23, 2018 10:54 am

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