Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: Rockytop62
- Order by date
-
crosstab report to calculate average job time by complexity
Finally figured it out... Requires the use of an Embedded Summary Calculation in the CrossTab report. For any others looking for a solution to this problem, you must have CR 2008 or later.. From that point, my solution turned out to be rather straight forward.. In my case: Create the Crosstab...- Rockytop62
- Post #6
- Forum: Business Objects: Crystal Reports 1 Formulas
-
crosstab report to calculate average job time by complexity
I have a crosstab report that shows the SUM of the hours... and I have a crosstab reports that shows the job count at each level of complexity.. I'm trying to figure out how to set up a cell formula that divides hours by job count... Columns are Job Complexity levels.. Rows are departments...- Rockytop62
- Post #3
- Forum: Business Objects: Crystal Reports 1 Formulas
-
crosstab report to calculate average job time by complexity
I'm using CR 11.0 I have record data fields as follows: JobRefNo JobComplexity Department JobHours The JobComplexity field is a dropdown with 5 options My crosstab report has the 5 JobComplexity options as Columns. The Departments are the rows. I need to calculate...- Rockytop62
- Thread
- Replies: 5
- Forum: Business Objects: Crystal Reports 1 Formulas
