Formula to Sum on Distinct Detail or sum of a max? 1

[checkai]

My report consists of Actual vs. Budget hours. In the details section the actual hours can have many records but the budget will only have ONE!!! So that one value gets written on every corresponding detail line. So I have grouped by Employee and Team and Region....What I want is ONE line per employee. However, when doing sums, I get a multiplied number for the budget records because of the duplicates in the details section. The amount of details could change for any given employee...I have tried putting the actual budget fields in the G3 area...it gives me the correct number, but then I cannot get the next group sums to work correctly....

Any help would be great!!

DCL

 

[IdoMillet]

Create a Running Total for the Budget totals and to ensure each Budget info gets summed only once for each Employee, set the "Evaluate" option (in the Running Total) to once per each employee.

Cheers,
- Ido

CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[checkai]

That looks like it should work...However, I am unsure of when to Reset Values, etc. to get the running totals by employee, team, business unit?

thanks again,
dlc

 

[IdoMillet]

To get the total for each employee, reset for each employee.
Same logic as you go up the hierarchy.
For Grand Totals, never reset.

hth,
- Ido

CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com