Hi there, am wondering if there is a way to SUM a calculated field that is in a sub-group. First group is Location / Second group is Encounter Type.
Field = [Total_Hrs_Sum]/[Enctrs_Count]. This gives me a number. Now, I need a sum of this field. Am not sure if this can be done as I get error messages when I try to run the report.
=Sum([Total_Hrs_Sum]/[Enctrs_Count]) should work. I am assuming you are putting this in a report right? If so, where are you putting the sum? In the report Footer? Also, what is the error you are getting?