Re: Reports 2.5 Summing across a row of data

Jenny Farnham <farnham_at_spot.Colorado.EDU> wrote in message news:811gkl$r6q_at_peabody.colorado.edu...
>
> I have a row of data on my report.
>
> aaaaaa bbbbbb 999999 999999
>
> The 9's are fields of data that came
> from formula fields. In other words,
> the source of these fields came from
> CF1, CF2, etc.
>
> I want to do this:
>
> aaaaa bbbbb 999999 999999 $999,999.99
>
> Where the last column is the sum of the
> other two columns that were derived
> from formulas.
>
> I can not reference these field
>
> I can't say return (cf1 + cf2);
>
> How does one sum ACROSS fields that
> are derived from formula column type fields?

I'm a little confused - if the formula columns exist in the same query - why can't you have a third formula that returns(:CF_1+:CF_2) ? I just generated a report and could sum the two formula's. Can you provide more information?

Good Luck,

Mike Smith
Baytree Associates
1-800-919-1974 Received on Fri Nov 19 1999 - 03:13:11 CET