April 25, 2007, 04:01 PM
PreethamAcross total Percentage
Hello All,
I have output like,
A B Total
C1 C1 C2 % C1 C2 % C1 c2 %
art 2 4 50 3 6 50 5 10 100
When i sum the cloumn total am getting percentage as 100% instead of 50%.
Can you help me
Thanks and Regards,
April 25, 2007, 05:51 PM
Leahquote:
C1 C1 C2 % C1 C2 % C1 c2 %
art 2 4 50 3 6 50 5 10 100
When i sum the cloumn total am getting percentage as 100% instead of 50%.
Have you tried ON TABLE SUMMARIZE
It should recalculate for you.
April 25, 2007, 06:25 PM
Francis MarianiUnfortunately, I don't think you can get PCT to recalculate when used in an ACROSS-TOTAL or ROW-TOTAL. You would assume it should work automatcally, but no.
Doesn't work:
DEFINE FILE CAR
SALESD/D15 = SALES;
END
TABLE FILE CAR
SUM
SALESD
PCT.SALESD/D6.2%
BY COUNTRY
ACROSS SEATS
ACROSS-TOTAL
ON TABLE SUMMARIZE
END
Workaround, using a two-verb request:
DEFINE FILE CAR
SALESD/D15 = SALES;
END
TABLE FILE CAR
SUM
SALESD AS 'TOTAL,SALES'
PCT.SALESD/D6.2% AS '%'
BY COUNTRY
SUM
SALESD AS 'SALES'
PCT.SALESD/D6.2% AS '%'
BY COUNTRY
ACROSS SEATS
ON TABLE SUMMARIZE
END
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
April 26, 2007, 03:46 AM
FrankDutchFrancis
I see you have this great solution.
I played a bit with it and have the following addition, since we want the sum ad the end and not ad the beginning we did this
DEFINE FILE CAR
SALESD/D15 = SALES;
SALESX/D15=SALES;
END
TABLE FILE CAR
SUM
SALESX NOPRINT
PCT.SALESX/D6.2% NOPRINT
BY COUNTRY
SUM
SALESD AS 'SALES'
PCT.SALESD/D6.2% AS '%'
BY COUNTRY
ACROSS SEATS AS ''
COMPUTE
TOTSALES/D12.2 = SALESX;
COMPUTE
TOTPERC/D6.2% = PCT.SALESX;
April 26, 2007, 10:51 AM
Francis MarianiFrank, that's quite interesting. Thanks for your example.
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
April 26, 2007, 11:14 AM
PreethamThanks everyine for the input. I am getting the required report.
Thanks