Formula problem

[shelo]

Hi,
I am trying to do what I think is a simple formula. My efforts have not brought me the correct results.
I am working with period end dates for payroll.
I simply need the regular hours and ot hours for a current period end date and the previous period end date.
Report has two parameters, current period end date and previous period end date. for some reason I am only getting the previous period end date.
In short, what is the formula for each to get the data, I am sooooooooo frustrated.

Any help would be awesome.
Thanks

 

[lbass]

We don't what how your fields display. Is there ONLY a period end date for each row of data? Is the same field {table.periodenddate} used in conjunction with each parameter? If so, your record selection formula should look like this:

(
{table.periodenddate} = {?CurrentPeriodEndDate} or
{table.periodenddate} = {?PreviousPeriodEndDate}
)

If this doesn't help, please show the contents of your current selection formula (report->selecton formula->record).

-LB

 

[crystalkiwibruce]

Don't get your record selection mixed up with the conditional totals.

Record Selection: You need to include both periods of data in your report, so
{Table.DateField} >= {@Previous Period Start Date}
Will select the correct records. You will need to use the Record Selection Formula rather than the Select Expert.

Then a Formula for CurrentPeriodRegularHours and CurrentPeriodOT and the same for the prior period.

Sum those 4 formulas and it should all look great.

Bruce Ferguson

http://www.crystalkiwi.com/nlog.htm