geomean

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i am not sure if this is the proper Group but i will post it here,
i want to calculate from a table the geomean of some values,
the table has a primary key id, suplier name, date, valuetm,
so for a period lets say 2 or 3 months i want to have the geomean result of the valuetm, is that possible? from a a query or with the help of a report;
any help would be great!
thank you for your time
 
i am not sure if this is the proper Group but i will post it here,
i want to calculate from a table the geomean of some values,
the table has a primary key id, suplier name, date, valuetm,
so for a period lets say 2 or 3 months i want to have the geomean result of the valuetm, is that possible? from a a query or with the help of a report;
any help would be great!
thank you for your time
Click to expand...

Here is a solution with a query:

SELECT Exp(Avg(Log([Nbr]))) AS GMean, tblGeoMean.Grp
FROM tblGeoMean
GROUP BY tblGeoMean.Grp;

It gives the geometric mean for the field Nbr, grouped by the field
Grp. You should be able to modify this for your situation.

HTH
Matthias Kläy
 
thank you so much

Matthias Klaey said:
i am not sure if this is the proper Group but i will post it here,
i want to calculate from a table the geomean of some values,
the table has a primary key id, suplier name, date, valuetm,
so for a period lets say 2 or 3 months i want to have the geomean result of the valuetm, is that possible? from a a query or with the help of a report;
any help would be great!
thank you for your time
Click to expand...

Here is a solution with a query:

SELECT Exp(Avg(Log([Nbr]))) AS GMean, tblGeoMean.Grp
FROM tblGeoMean
GROUP BY tblGeoMean.Grp;

It gives the geometric mean for the field Nbr, grouped by the field
Grp. You should be able to modify this for your situation.

HTH
Matthias Kläy
Click to expand...
 
Back
Top