Resources totally issue

G

Ginger

What I want to do is sum the hours for the resources in
each of two groups. The approach I have taken is to add a
column for each group and created a formula for the first
column:
IIf([Resource Group]="EPG",Work/60,0)

And for the second column:
IIf([Resource Group]<>"EPG",Work/60,0)

This gives me the correct answer whenever all the
resources assigned to a task are in the "EPG" group (first
case) or all of the resources are not in the group (second
case), but for any task with a mixture of resources, it
gives "0" for the first case and shows all the hours in
the second case/column. What I want it to do is provide
in the first column a sum of the work hours for the
resources in the EPG group for that task and in the second
column, a sum of the work hours for the resources not in
the EPG group for that task. Is there a way to do it?
 
R

Rod Gill

Hi,

Formulae will only work on the Task fields available to it. Where you have
two or more resources, you need to work at an assignment level. The only
solution for that is some VBA code.

--
Rod Gill
Project MVP
For Microsoft Project companion projects, best practices and Project VBA
development services
visit www.projectlearning.com/
 
Top