Hello Everyone,
Really hope someone can help.
I am working with 4 columns:
CustomerID,
StartDate(datetime)
EndDate(datetime)
Duration (in days)
I need to get a total of Duration.
We can have multiple activites started per day, but just 1 per customer per day. Unfortunately, the data has multiple starts per day for the customer.
I created 2 groups, 1 by customer, 1 by startdate (for each day).
I placed the details in the group header so I only see the 1st record for the day for each customer. I suppressed the details. However, when I summaries, it includes all of the data. I tried a formula that said if the current value = the next then 0 else duration. But can't summaries that.
My data looks like this:
Cust startdate stopdate duration
1 4/1/11 12:23 4/10/11 19:41 10
1 4/1/11 14:19 4/10/11 21:22 10
1 4/12/11 15:23 4/13/11 14:09 1
I need a total for that customer to = 11
Any ideas?
IP Logged
