Print Page | Close Window

Summarize group data calculation field

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Tips and Tricks
Forum Discription: Have you learned some great tricks to share with the group? Post them here!
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=14380
Printed Date: 16 May 2024 at 6:35pm


Topic: Summarize group data calculation field
Posted By: Libby
Subject: Summarize group data calculation field
Date Posted: 16 Sep 2011 at 4:58am

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


Print Page | Close Window