How to Create Weekly Groups starting Wednesday 1

[mwake]

I'm using CR10 and trying to recreate an excel graph which has a weekly running total of new subscribers. The key dates are Wednesdays (3/30, 3/23, etc). How do I create this grouping in Crystal, so I can summarize and graph the running total??

 

[bdreed35]

Create a formula like this to group on:

//@Wed_Week
if dayofweek({table.date}) in [4 to 7] then
{table.date} - (dayofweek({table.date})-4)
else
{table.date} - (dayofweek({table.date})+3)

You can group on this, and then create your summaried, and then create a chart off of that.


~Brian

 

[lbass]

You could also use the following for your group field:

{table.date}-dayofweek({table.date},crWednesday)+1

-LB

 

[mwake]

That's just what I needed!!

Thanks Brian!!