Date Roll Up

[Crystalguru]

I need to do a date roll up....trying to figure out how to do this.
Here's my example:
User selects a {?StartDate} = 2/9/2003
The report is going to display:
2/9/2003 : 92.3%

In the background, here's what I need it to do.
2/9= 91.5
2/8=91.9
2/7=91.9
2/6=92.3
2/5=93.0
2/4=92.8
2/3=92.6
Add all the percentages and divide by 7 to get the overall % of 92.3 (which is displayed on the report)

Basically, it is doing a Last7days roll up. I had the selection formula doing {date_day} in Last7days, but it only selects from current date. I need the {?StartDate} parameter in there.

Help, please?

thanks

 

[stormtrooper]

You need to include the parameter in your selection formula as well.

 

[Reebo99]

Selection Formula :

{YourRecordDateField}in DateAdd("d",-7, {?StartDate}) to {?StartDate}

Thid will give you the correct details at least. Reebo
Scotland (Raining)