Skip to Content
0
Former Member
May 20, 2010 at 12:26 PM

How to summarize formula field which has DateDiff function

255 Views

Hi Experts,

I have one data field in my data base. I am calculating time difference in minutes between current date and next date of record.

For that i have created one formula named as "DateDiff":

DateDiff ("n", {Sheet1_.Date }, next({Sheet1_.Date }))

I am able to calculate difference in Minutes.

At the end in Page Footer or Report Footer, I want to add summarize this field by sum function. So i get total minutes.

Example.

Customer Order ID Date (Database Field) TimeDiff (Formula Field)

C1 10001 1/1/2010 10:00:00 AM

C1 10002 1/2/2010 11:00:00 AM 1500 min.

C1 10003 1/2/2010 12:00:00 AM 60 min.

SO in Page or Report Footer I want: Toal TimeDiff: 1560 min.

when I am trying to add summary by Right Click on Formula -> Insert -> Summary , I am not able to see this "Insert" option in that dialogue box.

So can you help me "how can i get summation of all time diff value (1560 in above example)??"

Thanks in advance,

Rishit Kamdar