Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Calculate Geo Mean in Crystal report; thread767-1586227

Status
Not open for further replies.

visit2me

MIS
May 21, 2010
17
US
I read previous thread dated back on Jan 2010. by LisaRR (Geometric Mean)
link to thread:
or thread767-1586227

Thanks everyone for their input on LisaRR thread. It works great for me too for each month calculation. however, I am in a situation that I need to calculate and display based on previous two months geo mean for current date and keep display records for last 12 months lines.
For example:
if i run my report for dec 2011, my report should displays 12 lines, one line for each 15 previous months. And display geo mean on each line based on previous 2 months. i have a group in my report on Month

Any help will be greatly appreciated,

Visit2me,
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top