Help -
I want to add up all the formula fields located from a group footer 4 to the higher level group footer 2. Because the sumation in group 4 is a formula, not a sum of the detail iline items, I cannot use the sum feature of crystal.
Problem
I cannot find a way to add each Group 4 formula field together in Group two.
Details:
Group 1 - Department
Group 2 - Employee
Group 3 - Project
Group 4 - Task
Detail line:
Project - Task - Hours [reported]
Group 4 footer:
Task code - Total hours (sum of Hours reported) - Billable hours (a formula field)
1. In the group 4 footer 'total hours' is a crystal sum of hours from many detail lines.
2. In the same group footer I've place an 'if, then' formula field that compares those 'total hours' to another table to see if they are availabe for billing or not. The appropriate number of 'billable hours' are the result.
I need to add these 'billable hours' together for the employee summery in footer 2.
Group 2 footer
Employee - Total hours reported - Total billable hours (problem field)
What I've tried...
- The sum feature does not work because the information needed is from a formula field, not the detail line.
- I cannot apply the folmula per detail line, because I have to first accumulate all like hours for a project, then compare the total to available billing hours.
- The running total feature does not present formula fields for summing.
Thanks,
Paul