I have a Total Percentage column that is being totalled instead of averaged in my Total row. I've looked through and found several instances of Across-Total and RECOMPUTE, but I can't get them to line up. My '> 120 Days %' always comes out as 278% instead of the 17% I'm looking for. How do I convert one column in my Row Total to be an average and not a total?

This is coming from an SQL query and so, naturally, my table it SQLOUT.

TABLE FILE SQLOUT
SUM
     Current/P33.2MC
     31___60_Days/P33.2MC
     61___90_Days/P33.2MC
     91___120_Days/P33.2MC
     121___150_Days/P33.2MC
     151___180_Days/P33.2MC
     __180_Days/P33.2MC
     Total/P33.2MC
     ___120_Days/P33.2MC
     COMPUTE 120_PERC/D2% = COLUMN0010 * 100; AS '% > 120'
BY  FSC_Reporting_Category
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE SET ASNAMES ON
ON TABLE COLUMN-TOTAL AS 'TOTAL'
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLEMBEDIMG ON
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
     INCLUDE = IBFS:/EDA/EDASERVE/_EDAHOME/ETC/endeflt.sty,
$
ENDSTYLE
END 

Any suggestions of where to look for answers would be appreciated!

Thanks,
Tony

This message has been edited. Last edited by: Pondog,

Tony,
I assume that COLUMN0010 is the percentage that you multiply by 100 to get an integer.
Did you try:

ON TABLE SUBTOTAL AVE. 120_PERC 

I couldn't get the subtotal and row total to appear together. It was either one or the other.

I tried a different approach where I eliminated the SQL that created COLUMN0010 and instead did a COMPUTE to create the percentage column. This allowed the SUMMARIZE command to do the work.

I appreciate your input regarding SUBTOTAL as I can now add it to my list of tools. Thanks!!