Focal Point
[CLOSED] Totals in Subhead

This topic can be found at:
http://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/7527082196

May 03, 2019, 11:49 AM
ecsuappdevstu2
[CLOSED] Totals in Subhead
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
May 03, 2019, 12:59 PM
BabakNYC
  
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
May 07, 2019, 07:44 AM
Tony A
... 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