Compute a Groups Totals Divide as a column value

[hortensiam]

Hi1,
I've two groups: states (g#1) and specialities (g#2)
In the foot of the group #2 i print two types of subtotals and the sum of these (three columns) and i want to print (4th. column) the computation of the (sum / total_group g#1) (the outer group). How can i do this?
I use CR8.0
thanks,

 

[IdoMillet]

Instaed of using the sum formula as a component within the final formula, use the raw expressions for these sums:

(Sum({field1}, {specialties}) + Sum({field2}, {specialties}))/Sum(..., {States})

- Ido

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

http://www.MilletSoftware.com