geomean

S

sotiris_s

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
 
M

Matthias Klaey

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
 
S

sotiris_s

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