[CLOSED] Totals in Subhead

May 03, 2019, 11:49 AM

ecsuappdevstu2

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,

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

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

In FOCUS since 1986	WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2
	WebFOCUS App Studio 8.2.06 standalone on Windows 10