Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only.

Join the TIBCO Community
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.


Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     SUM (COL1+Col2) [CLOSED]

Read-Only Read-Only Topic
Go
Search
Notify
Tools
SUM (COL1+Col2) [CLOSED]
 Login/Join
 
Silver Member
posted
My table (result of a join) consists of the following values:
KEY CAMT KEY PAMT
2514 1122151.3500 2514 1094060.0000

I now want to add CAMT and PAMT, So my result set would be:
KEY NEWSUM
2514 2216211.3500

How do i do this?

This message has been edited. Last edited by: Shubha Manjit,


WebFOCUS 7.6
Windows, All Outputs
 
Posts: 29 | Registered: February 21, 2011Report This Post
<FreSte>
posted
Hi,

Have you read Chapter 1, page 1, paragraph 1 ??
 
Report This Post
Virtuoso
posted Hide Post
Yes...this is pretty basic

DEFINE FILE WHATEVER
NEWSUM/D12.4 = CAMT + PAMT;
END
 
Posts: 1903 | Location: San Antonio | Registered: February 28, 2005Report This Post
Silver Member
posted Hide Post
Im very sorry for posting such a basic question.

I have done SUM before in define. I dont know why it dint occur to me at all. I kept trying to do it in TABLE FILE and nothing I tried worked, then is when I posted. It was just a rough day yesterday and I went for a esy option of posting than doing the research myself. I apologise for that.

Than you very much for still responding to my question.


WebFOCUS 7.6
Windows, All Outputs
 
Posts: 29 | Registered: February 21, 2011Report This Post
Virtuoso
posted Hide Post
Rough Days happen Wink
 
Posts: 1903 | Location: San Antonio | Registered: February 28, 2005Report This Post
Expert
posted Hide Post
Did you get it to work?
SUM COMPUTE CAMTandPAMT/D20.4 = CAMT + PAMT;
Rough days happen to the best of us... I hope today is better. Wink
 
Posts: 3132 | Location: Tennessee, Nashville area | Registered: February 23, 2005Report This Post
Silver Member
posted Hide Post
having a great day so far Smiler..I got it to work.

all that I touch today is gold Wink still wondering what I did so differently today when compared to yesterday...


WebFOCUS 7.6
Windows, All Outputs
 
Posts: 29 | Registered: February 21, 2011Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     SUM (COL1+Col2) [CLOSED]

Copyright © 1996-2020 Information Builders