In Gantt View want separate columns for Work by Resource Group

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
Fri Nov 09 13:31:02 PST 2007

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


"Cyn" <Cyn@discussions.microsoft.com> wrote in message
news:B4F25D91-8666-45C9-8D8B-2A12DC376869@microsoft.com...
> 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.