Rounding and calculations

  • Thread starter Thread starter jderrig
  • Start date Start date
J

jderrig

Does anyone know the reason that I come up with a
different number by using an average function than if I
were to create the calculation manually.

Example:

If I use the avg function to come up with ROLE
=Sum(Savings/Equity-Inv) results in 4.6%
=Avg(ROLE) results in 1.82%

I have ROLE figured in a query and then try to average the
total ROLE for the entire list in a report.
 
I think it has something to do with the order of
operations. Should the equation look like:

Savings
_________
Equity-Inv


Or:

Savings
_______ - Inv
Equity


If it's the first, then you need a second set of
parenthses.


=Sum(Savings/(Equity-Inv))

Chris Nebinger
 
Back
Top