Prob. in placing a formula in group footer based on Group type

[jpd01]

I have 3 fields listed out in a detail section

TYPE Value margin% gross

Type1 2000 10 200 (2000 * 10)/100
Type1 3000 20 600 (3000 * 20)/100
Type1 4000 10 400 (4000 * 10)/100
----------------------------------------
Total Type1 9000 0.133 1200(placed in group footer)
(formula @test1: 1200/9000 = 0.13333)
----------------------------------------
TYPE Value margin% gross

Type2 3000 10 300 (3000 * 10)/100
Type2 2000 20 400 (2000 * 20)/100
Type2 1000 20 200 (1000 * 20)/100
----------------------------------------
Total Type2 6000 0.15 900(placed in group footer)
(formula @test1: 900/6000 = 0.15)
----------------------------------------
In the above mentioned group footer, (this is what needed)

but,formula test1 = Sum(gross)/Sum(Value) need to be applied.but when previewed in both the listing I'm getting the formula result as 0.1333 only. why does the formula does not refreshed based on the grouping type1 and type2.
why does the result 0.15 does not come for the type 2 result.how should the formula be placed?

hope I'm clear.

Thanks.

 

[kenhamady]

Your formula:

Sum(gross)/Sum(Value)

Is divigin the GRAND totals. To do the subtotals you need:

Sum(Gross, GroupField) / Sum(Value, GroupField) Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guide to using Crystal in VB

http://www.kenhamady.com/

tek@kenhamady.com