Crystal Reports Compare date/time difference

Technical Questions
Crystal Reports Forum : Crystal Reports 9 through 2020 : Technical Questions

Topic: Compare date/time difference
	<< Prev Page of 4

Author	Message
DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	Posted: 27 Sep 2012 at 1:39pm
	You used average? This is going to be in total minutes not the 'days minutes' format
	IP Logged

DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	Posted: 27 Sep 2012 at 1:39pm
	I think it is set to sum, not average
	IP Logged

rlivermore Groupie Joined: 27 Sep 2012 Online Status: Offline Posts: 70	Posted: 27 Sep 2012 at 1:50pm
	It's set to average.
	IP Logged

DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	Posted: 27 Sep 2012 at 1:57pm
	Look at each row and see if the data is correct per row then see if there are some really high values that are setting your average off.
	IP Logged

rlivermore Groupie Joined: 27 Sep 2012 Online Status: Offline Posts: 70	Posted: 27 Sep 2012 at 2:04pm
	Not sure what constitutes a high number but some of the tickets have been open for more than 20 days and some of them have negative dates/times as the work was completed before the ticket was opened.
	IP Logged

DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	Posted: 27 Sep 2012 at 2:08pm
	20 days would seem to do it. If it is not what you want to see then you will have to rethink how or what you want to calculate.
	IP Logged

rlivermore Groupie Joined: 27 Sep 2012 Online Status: Offline Posts: 70	Posted: 28 Sep 2012 at 5:16am
	Ok not sure where to go from here but I appreciate all of your help!
	IP Logged

<< Prev Page of 4

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.047 seconds.