Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] Totals in Subhead
Go
New
Search
Notify
Tools
Reply
  
[CLOSED] Totals in Subhead
 Login/Join
 
Member
posted
I used this code to find the totals for the number of applicants within each state and the total that were accepted:

 ON AS_ADMISSIONS_APPLICANT.AS_ADMISSIONS_APPLICANT.HIGH_SCHOOL_STATE SUBFOOT
"Number of apps accepted: <ST.AS_ADMISSIONS_APPLICANT.AS_ADMISSIONS_APPLICANT.Accept "
"Number of apps: <ST.PIDMCNT " 


It worked in the subfoot but not in the subhead. Is there any way to make this work in the subhead?

This message has been edited. Last edited by: FP Mod Chuck,


WebFOCUS 8.2, Windows 10
 
Posts: 6 | Registered: October 23, 2018Reply With QuoteReport This Post
Virtuoso
posted Hide Post
  
DEFINE FILE CAR
TOT_COUNTRY/D12=RCOST;
END
TABLE FILE CAR
SUM TOT_COUNTRY NOPRINT BY COUNTRY
SUM RCOST
BY COUNTRY
SUBHEAD
"TOTAL RETAIL COST FOR COUNTRY <TOT_COUNTRY"
BY CAR
END


WebFOCUS 8206, Unix, Windows
 
Posts: 1720 | Location: New York City | Registered: December 30, 2015Reply With QuoteReport This Post
Expert
posted Hide Post
... or without the define nor multi-verb request -
TABLE FILE CAR
SUM
    RCOST WITHIN COUNTRY NOPRINT
    RCOST
BY COUNTRY
ON COUNTRY SUBHEAD
"TOTAL RETAIL COST FOR COUNTRY <ST.C1"
BY CAR
END


T



In FOCUS
since 1986
WebFOCUS Server 8.2.01M, thru 8.2.06 on Windows Svr 2008 R2  
WebFOCUS App Studio 8.2.06 standalone on Windows 10 
 
Posts: 5617 | Location: United Kingdom | Registered: April 08, 2004Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] Totals in Subhead

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.