Date Range

[khshankar]

I am using CR 8.5 and Oracle

I need to find the average of the last 5 weeks by
day. For example, to determine Monday's volume forecast, I want to take an average of the last 5 Mondays. Is this possible in Crystal if so what formula I have to use.


Thanks

 

[lbass]

Try:

//{@Monday}:
if dayofweek({table.date}) = 2 then {table.forecast}

Then create a second formula:

sum({@Monday},{table.group})/5

If you are not doing this at a group level, then remove the group condition.

-LB