J
Junior
I am having a slight problem. My report calculates an average value,
and reports that number in the footer of a group which we will call Lot
Group - let's call the field [AvgNumber]. I then have another group,
which we will call Product Group - what I would like to do is sum all
the average values calculated in the Lot Groups, and report that value
in the footer of the Product Group. Lot Group is a sub-group of
Product Group.
I know - sounds real simple, but I can't seem to get it. If I place a
text box with the control =Sum([AvgNumber]) in the footer of the
Product Group, I am prompted for a parameter when I run the report. So
then I tried the following =Sum(Avg([AvgNumber])), and I get and error
stating that aggregate function cannot be used here.
Any help would be appreciated.
and reports that number in the footer of a group which we will call Lot
Group - let's call the field [AvgNumber]. I then have another group,
which we will call Product Group - what I would like to do is sum all
the average values calculated in the Lot Groups, and report that value
in the footer of the Product Group. Lot Group is a sub-group of
Product Group.
I know - sounds real simple, but I can't seem to get it. If I place a
text box with the control =Sum([AvgNumber]) in the footer of the
Product Group, I am prompted for a parameter when I run the report. So
then I tried the following =Sum(Avg([AvgNumber])), and I get and error
stating that aggregate function cannot be used here.
Any help would be appreciated.