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.



Read-Only Read-Only Topic
Go
Search
Notify
Tools
Totals
 Login/Join
 
<Lee Roper>
posted
I have a report that uses Across columns. Currently, I am using row totals to get grand total amounts for two fields, Claim and Admin Fees. Following these two row totals, I need a third field, Claim + Admin Fees. I've been exporting it to Excel and adding this column manually, but my boss tells me I should be able to do this with WebFocus, but I haven't been able to figure out how. I've been reading up on Across-totals but when I tried to apply this, I get an error message telling me that verb objects times retrieved columns exceeds maximum. Can someone help?
 
Report This Post
dhagen
Virtuoso
posted Hide Post
Example:

TABLE FILE GGSALES
SUM DOLLARS UNITS
BY REGION
ACROSS CATEGORY
COMPUTE C_TOTDOL/D10 = C1+C3+C5;
COMPUTE C_TOTUNI/D10 = C2+C4+C6;
END

Output
Category
Coffee Food Gifts C_TOTDOL C_TOTUNI
Region Dollar Sales Unit Sales Dollar Sales Unit Sales Dollar Sales Unit Sales
----------------------------------------------------------------------------------------------------------------
Midwest 4178513 332777 4338271 341414 2883881 230854 11,400,665 905,045
Northeast 4164017 335778 4379994 353368 2848289 227529 11,392,300 916,675
Southeast 4415408 350948 4308731 349829 2986240 234455 11,710,379 935,232
West 4473517 356763 4202337 340234 2977092 235042 11,652,946 932,039[/code]

This message has been edited. Last edited by: <Mabel>,
 
Posts: 1102 | Location: Toronto, Ontario | Registered: May 26, 2004Report This Post
<Lee Roper>
posted
Thanks for the suggestion. I have been able to get this to work for one computed column, but when I try to add a 2nd column, it gives me an error, saying Error Parsing Request.

Code I am using:

TABLE FILE NEWCLAIM
SUM
CLM_DET_AMT AS 'Clm Pmt Amt'
FEES AS 'Admin Fees'
BY
EESTAT AS 'Status'
BY
CODIV1 AS 'Division'
BY
ExpTyp AS 'Expense Type'
ACROSS
Plan
COMPUTE
TOT_CLAIMS/D12.2 = C1 + C3 + C5 + C7 + C9;
COMPUTE
TOT_FEES/D12.2 = C2 + C4 + C6 + C8 + C10;
END
 
Report This Post
dhagen
Virtuoso
posted Hide Post
This is a never fail method:


TABLE FILE NEWCLAIM
SUM COMPUTE C_CLM/D12.2 = CLM_DET_AMT; NOPRINT
COMPUTE C_FEE/D12.2 = FEES; NOPRINT
BY EESTAT AS 'Status'
BY CODIV1 AS 'Division'
BY ExpTyp AS 'Expense Type'
SUM CLM_DET_AMT AS 'Clm Pmt Amt'
FEES AS 'Admin Fees'
BY EESTAT AS 'Status'
BY CODIV1 AS 'Division'
BY ExpTyp AS 'Expense Type'
ACROSS Plan
COMPUTE TOT_CLAIMS/D12.2 = C_CLM;
COMPUTE TOT_FEES/D12.2 = C_FEE;
END
[/code]

This message has been edited. Last edited by: <Mabel>,
 
Posts: 1102 | Location: Toronto, Ontario | Registered: May 26, 2004Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic


Copyright © 1996-2020 Information Builders