Filter to show who entered actual hours

[Joe]

From the Resource Usage View, I want to filter out resources that did not
enter actuals for a specific day. I created a filter to show where actual
hours are greater than zero. Now how do I get the filter to show if the
actual hours is greater than zero for a specific day?

 

[John]

From the Resource Usage View, I want to filter out resources that did not
enter actuals for a specific day. I created a filter to show where actual
hours are greater than zero. Now how do I get the filter to show if the
actual hours is greater than zero for a specific day?

Joe,
I'm afraid that can't be done with a simple filter. What you want is to
query the timescaled data and that is beyond the capability of filters.

There are basically two choices. One is to manually set a spare flag
field (e.g. Resource Flag1) for those resources who have no entry for a
particular day (identified by manually reviewing the timescaled data).
The second is to use an advanced feature of Project, namely VBA to
search the timescaled data for the information and then set the flag
automatically. Clearly the latter approach is quicker and more efficient
but it does require some knowledge of VBA.

John
Project MVP

 

[Joe]

Thanks John, I was afraid that was going to be the answer. I will look at
running a query against the Timephased data.

 

[John]

Thanks John, I was afraid that was going to be the answer. I will look at
running a query against the Timephased data.

Joe,
You're welcome.

John