Using weightedaverage function in Crystal

[Bonediggler]

Hi there--


I am building a report that has 8 fields, the first being date (mm/dd/yyyy). The report reflects a month of data and has subtotals grouped on both the weekly and monthly level.

I successfully used the WeightedAverage function to calculate subtotals at the weekly level for 3 fields.

However, when using weightedaverage for the monthly calculations for the same fields, they merely return the value from the last weekly subtotal.

The monthly subtotal calculation is as follows: (field1, field2, date field, "monthly")

Any help is much appreciated.

 

[Madawc]

Crystal ought to give you the option of creating a summary total weighted average for the whole report, without the need to define your own formula. If you're not already familiar with Crystal's automated totals, see FAQ767-6524.

It helps to give your Crystal version - 8, 8.5, 9, 10, 11 or whatever. Methods sometimes change between versions, and higher versions have extra options.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[Bonediggler]

Hey Madawc...that works perfectly!

Thanks for the help.

(It's version 11 by the way.)