Path: newssvr20.news.prodigy.com!newsmst01.news.prodigy.com!prodigy.com!rip!news.webusenet.com!peer01.cox.net!cox.net!cyclone1.gnilink.net!spamkiller2.gnilink.net!nwrdny02.gnilink.net.POSTED!53ab2750!not-for-mail From: "news.verizon.net" Newsgroups: comp.databases.oracle.server Subject: Oracle Reports: Formula Columns ? Lines: 20 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.3790.0 X-Mimeole: Produced By Microsoft MimeOLE V6.00.3790.0 Message-ID: Date: Mon, 07 Jul 2003 23:24:18 GMT NNTP-Posting-Host: 162.83.180.44 X-Complaints-To: abuse@verizon.net X-Trace: nwrdny02.gnilink.net 1057620258 162.83.180.44 (Mon, 07 Jul 2003 19:24:18 EDT) NNTP-Posting-Date: Mon, 07 Jul 2003 19:24:18 EDT Xref: newssvr20.news.prodigy.com comp.databases.oracle.server:237104 Hello Everyone, I need to know how to get the sum of two column formulas (cf_win, cf_loses) on each row and the percentage of one particular column (win %). Here is an example of how the final report should look. SITE WINS LOSES DECISIONS WIN % ----- ------ -------- ------------- ------ A 10 5 15 67% B 35 10 45 78% C 8 2 10 80% --- --- ---- ---- Totals 53 17 70 76% Thanks Richie