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