BusinessObjects Board

Crystal Enterprise 9: How to Calculate average for datediff

building reports crystal reports legacy
#1

So I have this statement that calculates the time difference. It uses the previous mod_date minus the current mod_date. Now I would like to get the average of each users time interval, basically average of DateDiff.

Below is the SQL to get the time interval:

(DateDiff ("s",previous({PROD_TRKG_TRAN.MOD_DATE_TIME}) ,{PROD_TRKG_TRAN.MOD_DATE_TIME}))/60

I’ve tried something like:

Select AVG(DateDiff ("s",previous({PROD_TRKG_TRAN.MOD_DATE_TIME}) ,{PROD_TRKG_TRAN.MOD_DATE_TIME}))/60

But I keep getting prompted for some numerical value on AVG().

If I type out Average instead of AVG for this statement:

Select Average(DateDiff ("s",previous({PROD_TRKG_TRAN.MOD_DATE_TIME}) ,{PROD_TRKG_TRAN.MOD_DATE_TIME}))/60

I get, “A field is required here” message, any ideas??

leke (BOB member since 2014-08-04)

#2

I think they have rules against cross-posting.

kevlray :us: (BOB member since 2010-06-23)