Formula Help w/limiting Detail

[themich]

I'm still learning Crystal. I wish that I could do this in Access. Any assistance would be greatly appreciated.

I have an if statment to pull the paycheck amts that is based on a deduction called vacation.

IF {PRT_CURRENT__CHECK_DEDUCT.Deduction_ID}="UVAC"
THEN ({CURRENT_PRT_CHECK.Regular_Pay}+{CURRENT_PRT_CHECK.Overtime_Pay})
ELSE 0

The problem is that some employees have two UVAC deductions per pay period and therefore the PayAMTs are shown twice in the detail. I did a count of the Pay and then divided the total Pay by the count for grouping total, but that won't work for the report total. I've tried grouping on all different fields w/the same result. Any advice would be welcomed.

Thanks,

 

[themich]

I'm guessing that my grouping is wrong?

 

[lbass]

Please don't start multiple threads on the same topic. Instead of what you are doing at the group level, insert a running total that evaluates on change of some field so that it calculates only for one of the two records; reset on change of group (employee). For the grand total, insert a second running total like the first except that reset = never. Of course running totals need to be placed in footer sections.

-LB

 

[themich]

Your input is greatly appreciated. I can't wait to try this tomorrow. My apologies for starting multiple threads on this topic, it won't happen again.