Averaging a formula

[fredjonze]

Hi,

I'm using Crystal 8.5 against SQL2k data. I have a number of call records. Group 1 is the date and group 2 is the calling number. I'm calculating the minutes of use per subscriber per day with a formula field. The @sub_billable_mins is a formula that sums the call seconds and divides by 60.

{@sub_billable_mins}/Count ({rs_wireless_usage_oct.we_s_mobile_id_number}, {rs_wireless_usage_oct.we_s_mobile_id_number})

I'm placing this formula in the group 2 footer. I want to average the mins/caller in the group 1 footer to get an 'average mins/caller/day'. I'm confusing something because the average function squawks.

Any ideas or hint are appreciated.

Thanks,

 

[chelseatech]

You should just be ablt to place the {@billable mins} in the details and right click to insert a sumamry of that - and select average.

The formula you've displayed can't be sumamrised because it is a summary already, and you can't sumamrise a summary.

If you need the count in your {billable mins} formula then you acn accumulate the sum and count using variables, and then use them to calcualte the average. Editor and Publisher of Crystal Clear

http://www.chelseatech.co.nz/pubs.htm