Suming a formula

[DaveAdlard]

Hi,

I have a problem that is driving me crazy.

I am working an average out for each customer and I need to sum all the averages together and not work out and overall average I have 6 groups and the average per customer is calculating correctly but I can't sum the averages up.

I can't use a running total or a formula as the average I have created isn't selectable.

Can anyone please help

 

[briangriffin]

Assuming the average summary field is in the customer group footer, put this formula in the footer also:

whileprintingrecords;
numbervar v_average;
v_average := v_average + average({TheFieldYou'reAveraging},CustomerField)


Then in the report footer this formula will display the sum:

whileprintingrecords;
numbervar v_average;
v_average