geomean

[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

 

[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

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

 

[Guest]

thank you so much

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

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