Hi,

I am trying to have column totals for a select few columns (the first 3 columns and the one called conservable days), it works for the first one (Count)but for some reason when I try to show the total for next two SUMS (Acute and ALC Days) it doesn't show up when I run the report. The last column total works fine (Conservable days)..it is just the middle two that don't show up. But when I do a total for all the columns (so simply putting in ON TABLE COLUMN-TOTAL AS 'TOTAL' without specifying the columns) it works fine. I just don't want column totals for those middle and last columns (since they are averages and percents, I do not want to sum those)

SUM
CNT.ZHOLD_CONSERVABLEDAY.SEG01.ACCOUNT_NUMBER/I5 AS 'Cases'
ZHOLD_CONSERVABLEDAY.SEG01.ACUTE_LOS/I5 AS 'Acute Days'
ZHOLD_CONSERVABLEDAY.SEG01.ALC_LOS/I5 AS 'ALC Days'
AVE.ZHOLD_CONSERVABLEDAY.SEG01.ACUTE_LOS/D12.2 AS 'Avg Acute LOS'
AVE.ZHOLD_CONSERVABLEDAY.SEG01.ALC_LOS/D12.2 AS 'Avg ALC LOS'
AVE.ZHOLD_CONSERVABLEDAY.SEG01.BENCHMARK_LOS AS 'Avg Benchmark LOS'
ZHOLD_CONSERVABLEDAY.SEG01.CONSERVABLE_DAYS AS 'Conservable Days'
COMPUTE Cons.Perc/D12.2% = ( ZHOLD_CONSERVABLEDAY.SEG01.CONSERVABLE_DAYS / ZHOLD_CONSERVABLEDAY.SEG01.ACUTE_LOS ) * 100; AS '% Conservable Days'
COMPUTE ALC.Perc/D12.2% = ZHOLD_CONSERVABLEDAY.SEG01.ALC_LOS / ( ZHOLD_CONSERVABLEDAY.SEG01.ACUTE_LOS + ZHOLD_CONSERVABLEDAY.SEG01.ALC_LOS ) * 100; AS '% ALC Days'
BY LOWEST ZHOLD_CONSERVABLEDAY.SEG01.FISCAL_YEAR_NAME NOPRINT AS ''
BY ZHOLD_CONSERVABLEDAY.SEG01.PHYSICIAN_SERVICE
HEADING
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE COLUMN-TOTAL AS 'TOTAL' 'CNT.ZHOLD_CONSERVABLEDAY.SEG01.ACCOUNT_NUMBER' 'ZHOLD_CONSERVABLEDAY.SEG01.ACUTE_LOS' 'ZHOLD_CONSERVABLEDAY.SEG01.ALC_LOS' 'ZHOLD_CONSERVABLEDAY.SEG01.CONSERVABLE_DAYS'

This message has been edited. Last edited by: <Kathryn Henning>,

Works OK using the CAR file sample database -

TABLE FILE CAR
SUM CNT.BODYTYPE
    RETAIL_COST
    DEALER_COST
    AVE.RETAIL_COST
    AVE.DEALER_COST
    AVE.SALES
    SEATS
    COMPUTE PROFIT/D12.2 = RETAIL_COST - DEALER_COST;
    COMPUTE PROFIT.PERC/D12.2 = (RETAIL_COST - DEALER_COST) / DEALER_COST * 100;
BY LOWEST COUNTRY NOPRINT
BY CAR
HEADING
ON TABLE SET PAGE NOLEAD
ON TABLE COLUMN-TOTAL AS 'TOTAL' 'CNT.BODYTYPE' 'RETAIL_COST' 'DEALER_COST' 'SEATS'
END

Might be time to raise a case and work with tech support on your specific situation.

T

Are you putting spaces between the single-quoted columns specified to display a column-total? Your code looks as if there aren't spaces between them. Add spaces if not.