cancel
Showing results for 
Search instead for 
Did you mean: 

Further manipulation of group/report footer summary values

Former Member
0 Kudos

Post Author: GarryC

CA Forum: Crystal Reports

Hi All,

Fairly new to Crystal, we use version 9 with an Oracle 8 database.

Below is an example of part of the reult of a report written by my predecessor....

Page Header Days Worked jobs completed Jobs per day

(database field) (database field) (formula field - jobs complete/days worked )

Detail 10 20 2

Detail 5 15 3

Detail 7 17 2.4

Group Footer 22 (Sum Days worked) 52 (sum jobs complete) 2.46 (Ave. jobs per day column)

My problem is the group footer for jobs per day should NOT be the average of the jobs per day column but should be sum jobs complete/sum days worked = 2.36

I would appreciate it greatly if anyone could advise me how to do this, is it possible within the footer summaries or would I need to do a formula, if this latter I'm not sure of the content and syntax. I was thinking of using the SQL expression editor as I'm familiar with SQL but will only go down this road if there's no other option, always assuming I can actually turn it on!

Thanks.

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

Post Author: SKodidine

CA Forum: Crystal Reports

Glad it worked.

Yes, I live and work in Anchorage, Alaska.

Former Member
0 Kudos

Post Author: GarryC

CA Forum: Crystal Reports

Superb.......simple when you know how! Thanks for the quick and useful reply.

Moving off on a complete tangent......do you live & work in Alaska? Sorry for asking but always been fascinated by Alaska.

Former Member
0 Kudos

Post Author: SKodidine

CA Forum: Crystal Reports

I would think you need a formula. Create one and in the formula workshop window, expand 'Report Fields' and then double click on the Sum function (a sigma sign next to it) for Sum days worked. Do the same to insert sum jobs completed.

Once both fields are inserted into the formula, place '/' between them for division.

The formula should look something like this.

(Sum ({ table.daysworked}) / (Sum ({table.jobscompleted})

Save and close. Place this formula in the group footer in place of 'Ave jobs per day' .