[CLOSED] Select Column Totals not showing on Report
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>,
8.0.0.2 Windows, All Outputs
July 27, 2015, 07:09 AM
Tony A
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
In FOCUS since 1986
WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2
WebFOCUS App Studio 8.2.06 standalone on Windows 10
July 27, 2015, 10:44 AM
CoolGuy
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.
8.2.02M (production), 8.2.02M (test), Windows 10, all outputs.