Skip to Content
Former Member
Jul 29, 2009 at 05:50 PM

Using a Formula that contains DateDiff in a Summary


I have a formula field in my report that uses DateDiff to return the number of seconds between the post of the previous record and the current record.

I'd like to have a summary that gives me the average of that value, but every way I have tried - Running Total, Summary or Formula using Average() won't let me use the original formula field in the summary.

Can anyone explain why? Is there a way I can get the average for this value?