Average of Count

[Danster]

I need to Average a Count thus
AVERAGE(COUNT(field, CondField)) but Crystal doesn't like it.

My scenario is I am counting the number of parts on sales orders.
SO1
Part1
Part2
Part3
Count = 3
SO2
Part1
Part2
Part3
Part4
Count = 4
I then need to get an average count of parts on sales orders so the boss knows a rough idea of how many parts per sales order over a large range of orders.
Can anyone assist?

cheers

 

[GJParker]

One way to do this would be to add 2 summaries to the Report footer

1. Count of Orders
2. Count of Parts

Then create a formula to get the average parts

Count of Parts/Count of Orders

HTH

Gary Parker
Systems Support Analyst
Manchester, England