Calc Fields in

[CCBtx]

I may be just having a mental block.

I have 5 records

Say:

Grapes 15

Pears 10

Grapes 20

Pears 5

Apples 30

I am producing a report. The report has a SUB-SUMMARY sorted by fruit type. I also have a field called fruit_count which sums the types (Grapes = 3, Pears = 2, Apples = 1)

So, my sub summary goes:

Grapes 2

Pears 2

Apples 1

Ok. here is the question. I have 5 total records. I want to divide the fruit_count by the total records (5). Can someone tell me how to do that INSIDE the SUB-SUMMARY section of the report?

Thanks,

Campbell

[comment]

Assuming your fruit_count field is defined as a summary field (Count of fruit_type), define a calculation field =

GetSummary ( fruit_count ; fruit_type ) / GetSummary ( fruit_count ; fruit_count )

and place it in your sub-summary by fruit_type part, formatted to display as percentage.

[CCBtx]

Excellent. Thank you very much