In Gantt View want separate columns for Work by Resource Group

[Cyn]

In MS Project 2003 I have set up a Resourse Group for the customer and one
for my company. I want to show Work in separate columns - Work, Customer Work
and Our Work. This seems so simple. I created two new text columns (text1 and
text2)and put the following formula:

text1=IIf([Resource Group]="Maven",[Work]/60,0)

With this approach, I get numbers but not the right numbers.

 

[JulieS]

Hello Cyn,

Have you assigned resources from both groups to any task? If so, I
would expect an error in the result as the resource group field wouldn't
equal a single group name. In quick testing with only resources from a
single group assigned to a task, I am getting the numbers I expected.

I hope this helps. Let us know how you get along.

Julie
Project MVP

Visit http://project.mvps.org/ for the FAQs and additional information
about Microsoft Project