Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Oracle Reports: Fomula Columns ?
"news.verizon.net" <richard.martes_at_verizon.net> schrieb im Newsbeitrag
news:0inOa.16235$Ha.2189_at_nwrdny02.gnilink.net...
> 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
>
Hi,
add a CS in your basic group in the data model,
then (in the property palette, use F4 to invoke)
set its source to the CF to be summed.
Then add the CS to your layout where you want.
hth, Jan Received on Tue Jul 08 2003 - 01:39:32 CDT