using field in detail for domain aggregate function

  • Thread starter Thread starter Craig
  • Start date Start date
C

Craig

I am trying to use information in a field in the detail
section of a report to calculate a davg in another field
of the detail section. Getting no result and no error.
Any ideas?

=Davg("[ipp]","incentive","[calcgrp]=reports!report1!
[calcgroup]")

Thanks, all.
 
Craig said:
I am trying to use information in a field in the detail
section of a report to calculate a davg in another field
of the detail section. Getting no result and no error.
Any ideas?

=Davg("[ipp]","incentive","[calcgrp]=reports!report1!
[calcgroup]")
Click to expand...


You don't want to include the reference inside the quotes,
you want to use the value in the reference:

=Davg("[ipp]", "incentive", "[calcgrp]=" &
reports!report1![calcgroup])
 
Back
Top