>>Sorry, Trey, I lied. Adding the payroll field gives me "SQL: GROUP BY clause is missing or invalid." My bad.
>
>Hi Jim,
>
>It looks like facilitydata.facrebate and facilitydata.discountrate are not aggregated too.
>
>Thanks,
>Aleksey.

Aleksey,

Trying to add those fields results in "Cannot GROUP by aggregate field." error. Thanks for trying, though.