Can you create multiple subtotals using FML? If you had code like:

 
TABLE FILE SAMPLE
SUM
BUDGET 
ACTUALS
COMPUTE VARIANCE/P12.2 = BUDGET - ACTUALS;
BY CAMPUS NOPRINT
BY SCHOOL NOPRINT
FOR SUM_ID
38 TO 43  AS 'SALARY EXPENSES' LABEL SALARY OVER
44  AS 'BENFIT EXPENSES' LABEL FRINGE OVER
46 ADD AS 'NON-SALARY EXPENSES' LABEL EXP OVER
BAR OVER
RECAP EXPTOT= SALARY + FRINGE + EXP; AS 'TOTAL' OVER
RECAP EXPTOT(6) = (EXPTOT(4)/EXPTOT(2)) * 100;  OVER
RECAP EXPTOT(12) = (EXPTOT(10)/EXPTOT(8)) * 100;  OVER
BAR AS '='
ON CAMPUS SUBHEAD
"<CAMPUS"
ON SCHOOL SUBHEAD
"<SCHOOL"
END
 

Right now I get the Salary, Benefits, Non-Salary Expenses totaled by school, but how can I also add an overall total for the entire CAMPUS?

So the output would look like:

West Campus                BUDGET   ACTUALS    VARIANCE
     School of Law
       SALARY EXPENSES     1,200    1,000          200          
       BENEFIT EXPENSES    1,000    1,000            0    
       NON-SALARY EXPENSES 2,000    1,000        1,000
     TOTAL                 4,200    3,000        1,200

     School of Business
       SALARY EXPENSES     1,200    1,000          200          
       BENEFIT EXPENSES    1,000    1,000            0    
       NON-SALARY EXPENSES 2,000    1,000        1,000
     TOTAL                 4,200    3,000        1,200

TOTAL WEST CAMPUS          8,400    6,000        2,400


East Campus                BUDGET   ACTUALS    VARIANCE
     School of Nursing
       SALARY EXPENSES     5,200    1,000        4,200          
       BENEFIT EXPENSES    1,000    1,000            0    
       NON-SALARY EXPENSES 2,000    1,000        1,000
     TOTAL                 8,200    3,000        5,200

     School of Journalism
       SALARY EXPENSES     1,200    1,000          200          
       BENEFIT EXPENSES    1,000    1,000            0    
       NON-SALARY EXPENSES 2,000    1,000        1,000
     TOTAL                 4,200    3,000        1,200

TOTAL EAST CAMPUS         12,400    6,000        6,400
    

Thanks,
Bethany

If you just add ON TABLE SUMMARIZE, what do you get?

Other option would be to run the same request immediately following the first (or in compound report format) without the BY fields / subheads.

Bethany

In stead of using the BY statement I would try to add on or more hierarchy levels if that would be possible.
You will have more control over the totals and subtotals.

You can calculate the average per campus.

You now have first two BY and then FOR
Have you tried to change the sequence of BY and FOR?