As a newcomer to Crystal Reports, I am having difficulty summarizing data by group 2 when I use calculated data by group 1. Specifically when I total my employee earnings and my employee investment contributions (group 1) and use the group earning and investment contributions summaries to calculate a companies match per employee then I am unable to summarize the companies match by location (group 2).
My calculation is:
if investment contribution/earnings > .05 then =.04 * earnings
else if investment contribution/earnings < .03 then = investment contributions
else (investment contributions/earnings -.03)/2 +.03)
This is where our company matches 100% of contributions up to 3% of earnings, 50% of 3% up to 5% of earnings.
I understand the concept of the 3 pass and running totals, but don't know specifically how to implement this....if in fact this is what is wrong with my report.
Libby
IP Logged