Hey guys, I promised I searched the forum before posting this and couldn't really find an easy way to do this. Please excuse if I missed any post.
TABLE FILE CAR
SUM SALES/D12M DEALER_COST PCT.DEALER_COST/D12.3
BY COUNTRY
BY CAR
ON TABLE SUMMARIZE
END
I'm trying not to remove the precision for PCT field on the grand total line. So instead of 100.000% it's nice to see just 100% specially we know its always going to be 100%.
Please let me know
Happy new years!This message has been edited. Last edited by: <Emily McAllister>,
According to the manual, you can only reformat ROW-TOTAL.
WebFOCUS 8206, Unix, Windows
December 31, 2015, 10:52 AM
Francis Mariani
TABLE FILE CAR
SUM
COMPUTE SALESD/D12M = SALES;
DEALER_COST
PCT.DEALER_COST/D12.3
BY COUNTRY
BY CAR
ON TABLE SUBFOOT
"TOTAL<ST.SALESD<ST.DEALER_COST<ST.PCT.DEALER_COST"
ON TABLE SET STYLE *
TYPE=TABFOOTING, HEADALIGN=BODY, COLOR=NAVY, JUSTIFY=RIGHT, $
TYPE=TABFOOTING, ITEM=1, COLSPAN=2, JUSTIFY=LEFT, $
END
You can use a report footing to show a subtotal. To have the reformatted SALES in the footing, a COMPUTE is required.
Francis
Give me code, or give me retirement. In FOCUS since 1991
Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
December 31, 2015, 11:36 AM
vaayu
Thank you Francis. I do have it in a COMPUTE both my $$ and %% fields and I am showing the totals in SUBFOOT. Just can't get rid of decimals in the TOTAL line. Here's the actual snippet from fex. SHould I be controlling this within the STYLE?
-SET &COUNT_FIELD = IF &AGEOPT EQ 0 THEN 'PARTICIPANTS' ELSE 'AGE_COUNT' ;
DEFINE FILE PLANASSET
TMPASS/A100=ASSET_CATEGORY;
TTLASS/A106=TMPASS||' '|'Total';
END
TABLE FILE PLANASSET
SUM
&COUNT_FIELD/D12 AS 'Participants'
BY LOWEST PLANASSET.SEG01.ASSET_CATEGORY NOPRINT
BY PLANASSET.SEG01.LEGAL_NM AS 'Investment'
SUM
COMPUTE BAL_AMT/D20.2M = &AMT_FIELD; AS 'Balance'
COMPUTE BAL_PCT/D12.3% = PCT.&AMT_FIELD; AS 'Percent of Total'
BY LOWEST PLANASSET.SEG01.ASSET_CATEGORY NOPRINT
BY PLANASSET.SEG01.LEGAL_NM AS 'Investment'
BY PLANASSET.SEG01.MONEY_SRC_NAME AS 'Money Source'
ON PLANASSET.SEG01.ASSET_CATEGORY SUBHEAD
"<ASSET_CATEGORY "
ON PLANASSET.SEG01.ASSET_CATEGORY SUBFOOT
"<TTLASS <+0> <ST.BAL_AMT<ST.BAL_PCT"
ON PLANASSET.SEG01.LEGAL_NM SUBFOOT
" <+0>INVESTMENT TOTAL<+0> <ST.BAL_AMT<ST.BAL_PCT"
ON TABLE SET PAGE-NUM OFF
ON TABLE COLUMN-TOTAL AS 'TOTAL' BAL_AMT BAL_PCT/D12%