Grouping Question 1

[1994mkiv]

I am working on a paycheck report and the report has to be grouped for each 2 weeks. I set the grouping and everything is working correctly except CR is grouping wrong weeks. CR might be grouping week 1 and 2 together but the way my company payroll works it has to be 2 and 3 together. Can somebody tell be how can I set this kind of grouping.

 

[lbass]

Try the following. Create a formula:

numbervar biwks := remainder(datepart("ww",{table.date}),2);
if biwks = 1 then
{table.date} - dayofweek({table.date}) - 6 else
if biwks = 0 then
{table.date) - dayofweek({table.date}) + 1

Insert your group on this formula. If that gives you the wrong set of weeks, switch the 0 and 1 (the value of biwks).

-LB