I am having an issue with a formula in my group footer dividing total dollars by a distinct count of units. I received an error a summary has been specified on non-recurring field. I have added:
Whileprintingrecords;
NumberVar X:= 0 ;

Whileprintingrecords;
NumberVar X := x + {@UnitCount} ;

Whileprintingrecords;
NumberVar X ;


Now the totals dollars are not summing, it's only returning the first value but the units are correct. Any suggestions would be appreciated.

Thanks,
Runner

The @unitcount is the number of pieces of equipment.  Each equipment has it's own number.

Edited by Runner - 11 Feb 2013 at 10:50am

Awesome!  That worked.  I really do appreciate your help.

Thanks.
Runner