I have a series of dates and I need to calculate the number days between them and number of days since last activity, and the number of days since first activity. Sample of the data set is below.
Cust ID Activity Date
1234 01/05/05
03/08/05
07/01/05
5487 02/15/05
03/07/05
04/25/05
to calculate the amount of days from the last activity day:
group by cust ID
select activity date in the list
go to Agreegate (the sum icon on the tab menu)
custom... or calculated
in the expression definition date() - activity date
//date() you can find in functions -> Constants folder
activity date from query Items tab//
to calculate amount days from first activity day do the same thing but group activity day in descending order
It somewhat worked it added a summary line with the correct informationbut how do I eliminate all the detailed lines.Ã, I tried deleting the detail from the reprot page but it removed the entire calculation.
In addition I tried using the count function to count the number of orders by customer and the totals are not correct.Ã, Again if I add a calc filed with a constant and then total it provides accurate counts otherwise the count is not working.Ã,Â
If you delete it from the report page, it also deletes it from the query. Try cutting it instead.
As for your count issue, what were you grouping by to do the count? Can you provide some examples of both your methods?
Try to hide cells insted of deleting. Box type -> hide.