Announcements
 Crystal Reports Forum : General Information : Announcements
Message Icon Topic: Calculate Avg Difference in Days by Month Post Reply Post New Topic
Author Message
reportwriter
Newbie
Newbie
Avatar

Joined: 09 Nov 2007
Location: United States
Online Status: Offline
Posts: 2
Quote reportwriter Replybullet Topic: Calculate Avg Difference in Days by Month
    Posted: 09 Nov 2007 at 1:33pm

How would I calculate and report the average difference in the number of days (between the beginning and end dates) by Month?  Data is averaged and reported by the end_date's month.

If I have this type of data:

begin_date   end_date
1/14/2007    2/6/2007
2/1/2007      4/2/2007
2/1/2007      2/28/2007
3/1/2007      3/25/2007

The difference “in days” for each record and the reporting month are:
Record 1            23            reported in “Feb”
Record 2            60            reported in “Apr”
Record 3            27            reported in “Feb”
Record 4            24            reported in “Mar”

The result of the crystal report should be:

Jan    Feb    Mar    Apr
0        25      24     60

I am new to Crystal Reports and pseudo code would help me get started.

Thank you for your help!

Pat



Edited by reportwriter - 13 Nov 2007 at 5:10am
Pat
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.031 seconds.