Issue

I'm using Amicus Assembly. I need a report that will tell me how many hours I billed each month for a particularly Matter Type (e.g., Leases, Real Property, Construction), etc.

Solution

The following example filters Amicus' "Time Entries" collection by:

Current User, Start Date, End Date and Billing Status

It then iterates over the resultant filtered collection, totalling the time spent and including only  entries whose associated file type is "Real Estate".

Time Entry Report - %[aa.currentuser.name] Real Estate Files

Start Date:           %[^BDate = formatdate(Calendar.Capture('Beginning Date of Report', Date()),"mm/dd/yyyy")]

End Date:             %[^EDate = formatdate(Calendar.Capture('End Date of Report', Date()),"mm/dd/yyyy")]

%[TotalBillableTime=0]

%[aa.timeentries.clearfilters]

%[AA.timeentries.AddFilter('EnteredBy', 'LIKE', aa.currentuser.name)]

%[AA.timeentries.AddFilter('Date', '>=', bdate)] 

%[AA.timeentries.AddFilter('Date', '<=', edate)]

%[AA.timeentries.AddFilter('Billingstatus', 'LIKE', '*billable*')]

%[ForEachBlock("T", AA.timeentries)]%[KeepBlockIf(T.Matter.FileType="Real Estate")]%[TotalBillableTime = TotalBillableTime + formatnum((T.ElapsedTime/3600),2)]%[EndBlock]%[EndBlock]

TOTAL Billable Time = %[TotalBillableTime] hours.

Dan Todes