TOUGH resource question

[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?

 

[Gérard DUCOURET]

Hello Ginger,
You can do that with a VBA procedure. If you are interested in, I can send you a sample code which
do that.

Gérard Ducouret