Can someone explain this to me? Maybe I'm supposed to know...but forgot.??
I've duplicated it with the car file. I want negative values to have ()brackets. If you will copy and run the fex below - you will see that you get brackets in the detail and the subtotal...uncomment the line and run it in Excel and you get brackets in the detail but -dash in the subtotal for negatives.


TABLE FILE CAR
SUM DEALER_COST/D7B
BY SEATS SUBTOTAL
ACROSS CAR
COMPUTE TOT/D7B = (C1 + C3 + C5 + C7 + C9 + C11)/6; AS Average
COMPUTE CW/D14B = TOT - DEALER_COST; AS 'LW - AVG'
-*ON TABLE PCHOLD FORMAT EXL2K
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
UNITS=IN,
SQUEEZE=ON,
GRID=ON,
ORIENTATION=LANDSCAPE,$

TYPE=DATA,BACKCOLOR='LIME',FIELD=TOT,$
TYPE=DATA,BACKCOLOR='YELLOW',FIELD=CW,$
TYPE=SUBTOTAL,BACKCOLOR='SILVER',$
TYPE=TITLE,
BACKCOLOR='SILVER',$

ENDSTYLE
END

TABLE FILE CAR
SUM DEALER_COST/D14B
BY SEATS SUBTOTAL
ACROSS CAR
COMPUTE TOT/D14B = (C1 + C3 + C5 + C7 + C9 + C11)/6; AS Average
COMPUTE CW/D14B = TOT - DEALER_COST; AS 'LW - AVG'
ON TABLE PCHOLD FORMAT EXL2K
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
UNITS=IN,
SQUEEZE=ON,
GRID=ON,
ORIENTATION=LANDSCAPE,$
TYPE=DATA,BACKCOLOR='LIME',FIELD=TOT,$
TYPE=DATA,BACKCOLOR='YELLOW',FIELD=CW,$
TYPE=SUBTOTAL,BACKCOLOR='SILVER',$
TYPE=TITLE,
BACKCOLOR='SILVER',$
ENDSTYLE
END