DateTime difference greater that 24 sorted by group

[njain76]

I have grouped the records in my report by a particular type. Each record in each group has a date time difference value. I want to count the number of records in each group that have a date time difference greater than 24. Please help.

Thanks

 

[synapsevampire]

Each record in each group, or each record in the details of each group have a date difference?

How is this date difference demonstrated, a numeric field, or it needs to be determined, or?

I will approach the problem at the detail level for each group:

Assuming that you have a value, create a Running Total to count those greater than 24:

Insert->Field Object->Right click Running Totals and select New

Add the difference field to the field to summarize, and select count

Under the evauluate select use a formula and place:

{table.differencefield} > 24

Set the Reset to Group.

Place the field in the group footer.

-k