Focal Point
[CLOSED] Need percentage of totals

This topic can be found at:
http://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/9787058295

November 02, 2010, 10:00 AM
JOE
[CLOSED] Need percentage of totals
I'm trying to obtain a percent to total off of each sum field. I have a row-total sum and need the percentages for each sum. Any samples out there. Thanks for any assistance possible!

 TABLE FILE SQLOUT
SUM 
     Option1
     HangUp
     Option2
     Option3
     TimeOut
     Operator
BY Market
HEADING
""
FOOTING
""
ON TABLE SET PAGE-NUM OFF 
ON TABLE ROW-TOTAL AS 'TOTAL'
ON TABLE COLUMN-TOTAL AS 'TOTAL'
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLCSS ON

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


WebFocus 7.7.02 WinXP
November 02, 2010, 10:22 AM
Prarie
Joe,

If you will do a search on - Percent Row
You will get many examples.
November 02, 2010, 10:41 AM
JOE
What I'm looking for is percent to totals:

Example:

opt1 opt2 opt3 total
east 500 400 600 1500
33% 27% 40% 100%
west 300 300 200 800
38% 38% 25% 100%
Grand Tot 800 700 800 2300
35% 30% 35% 100%


Thanks!


WebFocus 7.7.02 WinXP
November 02, 2010, 11:24 AM
j.gross
Look up RECOMPUTE and SUMMARIZE