August 01, 2006, 12:30 PM
neuroRECAP/RECOMPUTE PERCENTAGES
I have the following:
TABLE FILE LMSUSERS2
SUM
-* 'LMSPRO2.SEG01.TOTPROFILES' AS 'Total,Profiles'
'LMSPRO2.SEG01.TOTQ' AS 'Total,Profiles'
'LMSPRO2.SEG01.Q1PER' AS 'Q1'
'LMSPRO2.SEG01.Q2PER' AS 'Q2'
'LMSPRO2.SEG01.Q3PER' AS 'Q3'
'LMSPRO2.SEG01.Q4PER' AS 'Q4'
'LMSPRO2.SEG01.Q5PER' AS 'Q5'
'LMSPRO2.SEG01.Q6PER' AS 'Q6'
'LMSPRO2.SEG01.Q7PER' AS 'Q7'
'LMSPRO2.SEG01.Q8PER' AS 'Q8'
'COLUMN-TOTAL'
BY 'LMSUSERS2.SEG01.LAST_NAME' NOPRINT
BY 'LMSUSERS2.SEG01.FST_NAME' AS 'First Name'
BY 'LMSUSERS2.SEG01.LAST_NAME' AS 'Last Name'
I am trying to get the COLUMN TOTALS to show total average instead of adding the percentages. I have searched through the forum and cannot find another post that actually fixes the issue. Does anyone know what I need to do to fix this?
"Bueller, Beuller, Beuller?"
August 01, 2006, 02:31 PM
PrarieTry
ON TABLE RECOMPUTE