Project 2007 - Problem with Multiple Tasks, Resources and Durations

[timothywelch]

I have a problem that I hope someone can help with. The attached projec
(http://www.demandmanagement.com/project/summary_problem.mpp), a scree
capture of which can be seen her
(http://www.demandmanagement.com/project/summary_problem.jpg), has som
tasks 3 to 8.

Task 3 uses resource DS and XYZ and occurs on Mon 1 Feb.
Tasks 4, 5 and 6 use resource DS and occur on Wed 3 Feb.
Tasks 7 and 8 use XYZ and occur on Fri 5 Feb.

I am wanting to have a column of data that will show the number o
physical days that resource DS is used and other column for the numbe
of physical days that resource XYZ is used.

So basically I want to see for the DS resource column "1 day" for task
3, 4, 5 and 6 but the summary in rows 1 and 2 to show on two days (a
resource DS is only used on Mon and Wed). And for the XYZ resourc
column, I want the column to show "1 day" for tasks 3, 7 and 8 but th
summary in rows 1 and 2 to show "2 days" (as resource XYZ is only use
on Mon and Fri).

I've tried to use the Duration1 field to show the DS resources day
using the formula:

IIf(([Resource Initials] Like "*DS*"),[Duration],0)

...with the option to SUM on rollup, and for the Duration2 field to sho
the XYZ resources days using the formula:

IIf(([Resource Initials] Like "*XYZ*"),[Duration],0)

...with the option to SUM on rollup. But as you can see, the rollups ar
showing 4 days and 3 days respectively (not 2 days and 2 days as
want).

Does anyone have any ideas how I can achieve this?

I've been struggling with this for weeks and would appreciate any help.

Thanks

 

[timothywelch]

Anyone any ideas?

 

[timothywelch]

I have looked at those views and they just don't do what I want. I
seems strange that you can't simply summarise a count of number o
days... after all, I'm sure many people want to be able to see somethin
in the Gannt that will show "this means x days work" to me. :