Focal Point
[SOLVED] How to avoid total line on two lines

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

September 15, 2016, 01:34 AM
Joao
[SOLVED] How to avoid total line on two lines
CA Warner your solution would be to eliminate the first SUM and following STUDENT ID NOPRINT
in order to have the one SUM statement as follows.

TABLE FILE RECORDS
SUM
STUDENTID
COMPUTE PERCENT/F6.2% = ( C2 / C1 ) * 100; AS "Percent"
RANKED BY TOTAL HIGHEST 10 STUDENTID NOPRINT
BY HS_DESC AS 'Highschool'
ON TABLE COLUMN-TOTAL AS ' '
ON TABLE PCHOLD FORMAT XLSX FORMULA
END
March 06, 2018, 11:40 PM
Joao
The solution to this issue can be found at the following link: https://www.informationbuilder...scriptions-same-line