Hello!  Started using CR 10 with my new job a couple months ago and this forum has proven to be a great resource - so thanks in advance to all the helpful people on here.  It’s my turn to ask a question though as I’ve finally come across something that has thoroughly stumped me.

I’ll try not to indulge in too many details, but suffice to say I’m trying to get to a figure for average time elapsed between minimum and maximum dates.

The table I’m working with has a one to many relationship on ACCOUNTID and DATE_MODIFIED.  I’ve grouped on ACCOUNTID, and in my group footer I have minimum(DATE_MODIFIED, ACCOUNTID), maximum(DATE_MODIFIED, ACCOUNTID), and a datediff between the two.

I went to Insert -> Summary to calculate the average datediff in the report footer, but much to my chagrin realized CR will not allow a summary of a summary.  I’ve spent more time than I should have this afternoon trying to identify a workaround, but can’t find any examples on the interwebs that work as a solution in this specific situation.

Any advice would be greatly appreciated – I’d be more than happy to include any additional details as necessary.