View previous topic :: View next topic
|
Author |
Message |
ballaswaroop
New User
Joined: 20 Sep 2005 Posts: 25
|
|
|
|
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 |
|
|
Nic Clouston
Global Moderator
Joined: 10 May 2007 Posts: 2455 Location: Hampshire, UK
|
|
|
|
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 |
|
|
steve-myers
Active Member
Joined: 30 Nov 2013 Posts: 917 Location: The Universe
|
|
|
|
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 |
|
|
RahulG31
Active User
Joined: 20 Dec 2014 Posts: 446 Location: USA
|
|
|
|
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 |
|
|
Rohit Umarjikar
Global Moderator
Joined: 21 Sep 2010 Posts: 3053 Location: NYC,USA
|
|
|
|
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 |
|
|
|