TWO SUMMARY LINES 1

[Zyberian]

hello, I need urgent help. The issue is I try to create two summary lines for the columns:

one for totals (ON TABLE COLUMN-TOTAL)
second one for average calculation of the columns (I am trying ON TABLE SUMMARIZE AVE. columnname).

the report only shows 1 summary line always - the last one. Any suugestions?

 

[Zyberian]

in addition to my post, this is how the report should read:

Date
Score
StudentName 1/1/05 2/1/05 etc.
Alex 10 9
Brian 9 10
David 5 5
Mike 8 10
______________________________
Team Total: 32 34
Team Average: 8 8.5

StudentName is a sort field. Date is across field.

 

[focwizard]

Well, I'm not surprised that SUMMARIZE and COLUMN-TOTAL are mutually exclusive, as both specify what to do at the end of a report. However, you CAN get what you want with a bit of creativity. If we DEFINE a field to be a constant, and use that as the MAJOR sort field, then we have TWO different fields on which to specify an action. The code looks something like this:

DEFINE FILE CAR
A/A1=' ';
END
TABLE FILE CAR
SUM SEATS 
BY A NOPRINT 
BY COUNTRY
ACROSS BODYTYPE
ON A SUMMARIZE   AVE. AS 'AVERAGE'
ON TABLE COLUMN-TOTAL AS 'TOTAL'
END

Since the constant 'A' only changes at the beginning and end of the report, we get both operations on the entire report.

 

[Zyberian]

great! Thanks, focwizard. it works.