Average Problems

[Greg]

I am trying to get the average amount current, over30, over 60, etc..... for
my report. I have the total of the balance, total of Currnet, Over 30, etc.
but unable to get the Average percent of each that is currnet, over 30
,etc..... Since my sum field is unbound I can't run an avg([Total_Current]
\ [Total_Balance]). How can I get this to work?


Thanks,
Greg

[Bob Quintal]

Re: Average Problems

"Greg" <gknapper@itlan .net> wrote in
news:IXxkb.3148 $Vf7.2302@nwrdn y02.gnilink.net :
[color=blue]
> I am trying to get the average amount current, over30, over
> 60, etc..... for my report. I have the total of the balance,
> total of Currnet, Over 30, etc. but unable to get the Average
> percent of each that is currnet, over 30 ,etc..... Since my
> sum field is unbound I can't run an avg([Total_Current] \
> [Total_Balance]). How can I get this to work?
>
>
> Thanks,
> Greg[/color]

I don't know how your report is set up, but an average of your
[total_current] \ [total_balance] !should! be equal to the average
of [current]\[balance] for the same grouping of records.

Bob

[Greg]

Re: Average Problems

Well after banging my head I think I found why it was not given me the right
results. I have been trying eveything but changing the "\" to "/" now it
work!!!! Thanks once again Bob for the help!!!! Hopefully somdeday I can
return the favor!!!


Greg


"Bob Quintal" <bquintal@gener ation.net> wrote in message
news:948c7ceeb9 b7ab8c296ce54c5 30e1da1@news.te ranews.com...[color=blue]
> "Greg" <gknapper@itlan .net> wrote in
> news:IXxkb.3148 $Vf7.2302@nwrdn y02.gnilink.net :
>[color=green]
> > I am trying to get the average amount current, over30, over
> > 60, etc..... for my report. I have the total of the balance,
> > total of Currnet, Over 30, etc. but unable to get the Average
> > percent of each that is currnet, over 30 ,etc..... Since my
> > sum field is unbound I can't run an avg([Total_Current] \
> > [Total_Balance]). How can I get this to work?
> >
> >
> > Thanks,
> > Greg[/color]
>
> I don't know how your report is set up, but an average of your
> [total_current] \ [total_balance] !should! be equal to the average
> of [current]\[balance] for the same grouping of records.
>
> Bob[/color]