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     [CLOSED] Compute field not working for RECAP

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[CLOSED] Compute field not working for RECAP
 Login/Join
 
getit
Platinum Member
posted
DEFINE FILE RPT123A
SUMMURL/A150 = '/rcaster/library/getreport?id='||'&SUMMGID'||'&'||'version='||'&SUMMVER';
END

TABLE FILE RPT123A
SUM
COL1 AS 'Items'
COL2 AS 'Amount in $'
COL3 AS 'Percent'
SUMMURL
-*BY TOTAL COMPUTE LBL/A20 = 'Cash '; NOPRINT
FOR RPTITEM
1 AS 'New ' LABEL R1 OVER
2 AS '0-30 ' LABEL R2 OVER
3 AS '31-60 ' LABEL R3 OVER
4 AS '60+ ' LABEL R4 OVER
RECAP
TCIP(1)/I6C = R2 + R3 + R4;
TCIP(2)/P18CS = R2 + R3 + R4;
TCIP(3)/P5S% = R2 + R3 + R4;
AS 'Total Cash ' OVER
5 AS 'Average Age' LABEL R5


Here are my results


Items Amount in $ Percent SUMMURL
New 68 412,439,847 /rcaster/library/getreport?id=R1529diihb5&version=00254
0-30 760 571,433,690 96% /rcaster/library/getreport?id=R1529diihb5&version=00254
31-60 200 23,911,128 4% /rcaster/library/getreport?id=R1529diihb5&version=00254
60+ 39 1,065,777 /rcaster/library/getreport?id=R1529diihb5&version=00254
Total Cash 999 596,410,595 100%
Average Age 22 /rcaster/library/getreport?id=R1529diihb5&version=00254



Why do I not see the URL for the RECAP column Total Cash

This message has been edited. Last edited by: Kerry,


App Studio Version 8202
windows Platform
SQL Server 2008/2012
 
Posts: 183 | Location: TX | Registered: January 22, 2007Report This Post
FrankDutch
Virtuoso
posted Hide Post
you want a total for an alpha field
that wont be easy




Frank
prod: WF 7.6.10 platform Windows,
databases: msSQL2000, msSQL2005, RMS, Oracle, Sybase,IE7
test: WF 7.6.10 on the same platform and databases,IE7

 
Posts: 2387 | Location: Amsterdam, the Netherlands | Registered: December 03, 2006Report This Post
getit
Platinum Member
posted Hide Post
No I just need to put a link on the Total field and when I do that , I get the links on all other fields but not the total field because it is blank.
Here is my style sheet

TYPE=REPORT,COLUMN=N2,TARGET=_blank, URL=(SUMMURL) ,ALT = 'Cash Items by Unit and Employee',$


App Studio Version 8202
windows Platform
SQL Server 2008/2012
 
Posts: 183 | Location: TX | Registered: January 22, 2007Report This Post
Tom Flynn
Expert
posted Hide Post
RECAP
TCIP(1)/I6C = R2 + R3 + R4;
TCIP(2)/P18CS = R2 + R3 + R4;
TCIP(3)/P5S% = R2 + R3 + R4;
TCIP(4)/A150 = R5;
AS 'Total Cash ' OVER


Tom Flynn
WebFOCUS 8.1.05 - PROD/QA
DB2 - AS400 - Mainframe
 
Posts: 1972 | Location: Centennial, CO | Registered: January 31, 2006Report This Post
getit
Platinum Member
posted Hide Post
what is R5?, I already have an R5 in the code.


App Studio Version 8202
windows Platform
SQL Server 2008/2012
 
Posts: 183 | Location: TX | Registered: January 22, 2007Report This Post
Tom Flynn
Expert
posted Hide Post
TCIP(4)/A150 = MAX.SUMMURL;


Tom Flynn
WebFOCUS 8.1.05 - PROD/QA
DB2 - AS400 - Mainframe
 
Posts: 1972 | Location: Centennial, CO | Registered: January 31, 2006Report This Post
getit
Platinum Member
posted Hide Post
quote:
TCIP(4)/A150 = MAX.SUMMURL;


Didn't Work.

Here is the error

(FOC345) EMR MODEL HAS AN UNRESOLVED LABEL: MAX.SUMMURL

I also tried TCIP(4)/A150 = SUMMURL; same error


App Studio Version 8202
windows Platform
SQL Server 2008/2012
 
Posts: 183 | Location: TX | Registered: January 22, 2007Report This Post
Tom Flynn
Expert
posted Hide Post
Why do you want a URL on a TOTAL line anyway?
You need to create the total line and the URL in separate TABLE and MORE the data together instead of RECAP, then report on the concatenated records...


Tom Flynn
WebFOCUS 8.1.05 - PROD/QA
DB2 - AS400 - Mainframe
 
Posts: 1972 | Location: Centennial, CO | Registered: January 31, 2006Report This Post
getit
Platinum Member
posted Hide Post
Hi Tom,
Thank you for looking into this.
That was the users requirement! The link on the total takes them to a detailed report in the report caster.


App Studio Version 8202
windows Platform
SQL Server 2008/2012
 
Posts: 183 | Location: TX | Registered: January 22, 2007Report This Post
Tom Flynn
Expert
posted Hide Post
Another thing:

I don't use FML unless there are 100% measures to be included; that is what FML is for. Adding an alpha column doesn't make much sense for FML... My Opinion...

A basic report for this should suffice...

Tom


Tom Flynn
WebFOCUS 8.1.05 - PROD/QA
DB2 - AS400 - Mainframe
 
Posts: 1972 | Location: Centennial, CO | Registered: January 31, 2006Report 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     [CLOSED] Compute field not working for RECAP

Copyright © 1996-2020 Information Builders