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.
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.