Hi All,

I am doing a compute on two across columns, and although I've designated D12.2% as the format for the compute, the subtotals are not coming out with a percent sign. I'm on an old version of WF, so maybe its a bug, but if its not, can someone advise me? Here is the code of my final report:

TABLE FILE HOLD_SMIPR
SUM
'CNT.HOLD_SMIPR.SEG01.EMPLOYEE' AS 'COUNT,HOLD_SMIPR.SEG01.EMPLOYEE'
BY 'HOLD_SMIPR.SEG01.DIV'
BY 'HOLD_SMIPR.SEG01.REG'
BY 'HOLD_SMIPR.SEG01.DIST'
ACROSS 'HOLD_SMIPR.SEG01.EXTORINT' AS ''
COMPUTE
GRAND_TOTAL/I5 = C1 + C2;
COMPUTE
IPR_PERCENT/D12.2% = C2 / GRAND_TOTAL * 100;

ON HOLD_SMIPR.SEG01.DIV SUBTOTAL AS '*TOTAL DIV'
ON HOLD_SMIPR.SEG01.DIV RECOMPUTE AS '*TOTAL HOLD_SMIPR.SEG01.DIV'

ON HOLD_SMIPR.SEG01.REG SUBTOTAL AS '*TOTAL REG'
ON HOLD_SMIPR.SEG01.REG RECOMPUTE AS '*TOTAL HOLD_SMIPR.SEG01.REG'
HEADING
"Store Manager Internal Placement"
" by Div, Reg & District through &NICEDATEEND"
ON TABLE SET PAGE-NUM OFF
ON TABLE SET BYDISPLAY ON
ON TABLE COLUMN-TOTAL AS 'TOTAL'
ON TABLE PCHOLD FORMAT EXL2K
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
UNITS=IN,
SQUEEZE=ON,
ORIENTATION=PORTRAIT,
$
TYPE=REPORT,
FONT='ARIAL',
SIZE=9,
$
TYPE=DATA,
COLUMN=N2,
BORDER-TOP=LIGHT,
BORDER-BOTTOM=LIGHT,
BORDER-LEFT=LIGHT,
BORDER-RIGHT=LIGHT,
$
TYPE=DATA,
COLUMN=N3,
BORDER-TOP=LIGHT,
BORDER-BOTTOM=LIGHT,
BORDER-LEFT=LIGHT,
BORDER-RIGHT=LIGHT,
$
TYPE=DATA,
COLUMN=N6,
BORDER-TOP=LIGHT,
BORDER-BOTTOM=LIGHT,
BORDER-LEFT=LIGHT,
BORDER-RIGHT=LIGHT,
$
TYPE=DATA,
COLUMN=N7,
BORDER-TOP=LIGHT,
BORDER-BOTTOM=LIGHT,
BORDER-LEFT=LIGHT,
BORDER-RIGHT=LIGHT,
$
TYPE=DATA,
COLUMN=N1,
BORDER-TOP=LIGHT,
BORDER-BOTTOM=LIGHT,
BORDER-LEFT=LIGHT,
BORDER-RIGHT=LIGHT,
$
TYPE=DATA,
ACROSSCOLUMN=N1,
BORDER-TOP=LIGHT,
BORDER-BOTTOM=LIGHT,
BORDER-LEFT=LIGHT,
BORDER-RIGHT=LIGHT,
$
TYPE=TITLE,
STYLE=BOLD,
$
TYPE=TITLE,
COLUMN=N2,
BORDER-TOP=LIGHT,
BORDER-BOTTOM=LIGHT,
BORDER-LEFT=LIGHT,
BORDER-RIGHT=LIGHT,
$
TYPE=TITLE,
COLUMN=N3,
BORDER-TOP=LIGHT,
BORDER-BOTTOM=LIGHT,
BORDER-LEFT=LIGHT,
BORDER-RIGHT=LIGHT,
$
TYPE=TITLE,
COLUMN=N6,
BORDER-TOP=LIGHT,
BORDER-BOTTOM=LIGHT,
BORDER-LEFT=LIGHT,
BORDER-RIGHT=LIGHT,
$
TYPE=TITLE,
COLUMN=N1,
BORDER-TOP=LIGHT,
BORDER-BOTTOM=LIGHT,
BORDER-LEFT=LIGHT,
BORDER-RIGHT=LIGHT,
$
TYPE=TITLE,
ACROSSCOLUMN=N1,
BORDER-TOP=LIGHT,
BORDER-BOTTOM=LIGHT,
BORDER-LEFT=LIGHT,
BORDER-RIGHT=LIGHT,
$
TYPE=TABHEADING,
SIZE=12,
STYLE=BOLD,
$
TYPE=TABFOOTING,
SIZE=12,
STYLE=BOLD,
$
TYPE=HEADING,
LINE=1,
JUSTIFY=CENTER,
$
TYPE=HEADING,
LINE=1,
OBJECT=TEXT,
ITEM=1,
SIZE=12,
STYLE=BOLD,
$
TYPE=HEADING,
LINE=2,
JUSTIFY=CENTER,
$
TYPE=HEADING,
LINE=2,
OBJECT=TEXT,
ITEM=1,
STYLE=ITALIC,
$
TYPE=SUBHEAD,
SIZE=10,
STYLE=BOLD,
$
TYPE=SUBFOOT,
SIZE=10,
STYLE=BOLD,
$
TYPE=SUBTOTAL,
BACKCOLOR=RGB(210 210 210),
$
TYPE=SUBTOTAL,
BY=1,
BACKCOLOR='YELLOW',
$
TYPE=ACROSSVALUE,
SIZE=9,
$
TYPE=ACROSSVALUE,
ACROSS=1,
STYLE=NORMAL,
$
TYPE=ACROSSTITLE,
STYLE=BOLD,
$
TYPE=GRANDTOTAL,
BACKCOLOR=RGB(210 210 210),
STYLE=BOLD,
$
ENDSTYLE
END

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

This is a demo fex, similar to yours. I can't see why the subtotals don't show the percent symbol. Try running this code - it works in our v7.7.05 environment. BTW, I don't think you need both a SUBTOTAL and a RECOMPUTE...

TABLE FILE EMPLOYEE
SUM
CNT.EMP_ID AS 'COUNT,EMPLOYEE'
BY DEPARTMENT
BY JOB_DESC

ACROSS BANK_NAME AS ''

COMPUTE
GRAND_TOTAL/I5 = C1 + C2;
COMPUTE
IPR_PERCENT/D12.2% = C2 / GRAND_TOTAL * 100;

WHERE BANK_NAME NE ''

ON DEPARTMENT RECOMPUTE AS '* SUBTOTAL DEPARTMENT'

ON JOB_DESC RECOMPUTE AS '* SUBTOTAL JOB_DESC'

ON TABLE RECOMPUTE AS '* GRAND TOTAL'

ON TABLE SET PAGE-NUM OFF
ON TABLE SET BYDISPLAY ON
ON TABLE SET HTMLCSS ON

ON TABLE PCHOLD FORMAT EXL2K

ON TABLE SET STYLE *

TYPE=REPORT, SQUEEZE=ON, FONT='ARIAL', SIZE=9, $
TYPE=SUBTOTAL, BACKCOLOR=RGB(210 210 210), $
TYPE=SUBTOTAL, BY=1, BACKCOLOR='YELLOW', $
TYPE=GRANDTOTAL, BACKCOLOR=RGB(210 210 210), STYLE=BOLD, $
END