Group by Location, but keep your field results in the Details so that they still display all the records you want.

Then create a formula for Location specific data and place it into your Group Header or Group Footer.

sum({table.days}, {@Location}) / distinctcount({table.location_field}, {@Location})

You'd probably want this in your footer so that the Group Name (the Location) can be in the Header for label purposes. Otherwise your label would need to go into the Page Header or Report Header unless you added another Group By on a value that is unique for each record, in which case you could have that unique value as Group #1 and use that Group Header for any labels needed on Group #2.


Edited by Erik - 08 Jun 2015 at 10:39am