I am trying to do a project count report by resource by type for each resource in our department. They should be included if they are assigned as an a resource at the point in time the report is run.
I am using the Analysis application, and the Project & Request Report dataset with the following criteria:
The issue I have is I can't get resources that maybe at one point in time been EXCLUDING a resource that was assigned on a project in the past, but is not assigned now. My attempt to do so is to include a filter where "Estimated Hours" not equal to 0 -- but that didn't work. I went as far as to re-add the resource to the project, set their schedule with 0 for all months, and resave it --- but they still showed up --- then I tried to remove them from the project, and that failed too. Not sure if when a resource is removed if their remaining/future estimate stays forever - or if the estimated hours is at the project versus resource level? Any ideas on how I can successfully create this report?
Example of issue: projects are showing up tied to someone w/out being currently assigned as a Resource:
RETURN RESULTS - RED ARROW PROJECT
RESOURCE LIST FOR PROJECT DOES NOT INCLUDE JEREMY