The report I'm now working on groups projects; and lists employees who worked on the project, and includes #Ints and #ofHrs among other fields. The project footer calculates the project average as follows: =Sum([#Ints]/Sum[#Hrs]). OK so far, but now I'd like to include an Index for each employee--=100*[#Hrs]/Sum([#Ints]/Sum[#Hrs])--the demoninator is the Project Average spelled out. It doesn't seem to work. Can this index be calculated on the report or do I have to go back and perform a project average update query and the have the report get that info??<br>
As usual "Thanks" for any input.
As usual "Thanks" for any input.