how do I control rollup values in a table that uses a group in Pr.

R

Renaud Duisit

Using MS-Project 2003.

My situation is:
I created a group based on a custom text field (task field).
I use this group in a view that will be used as a dashboard. This view shows
milestones and dates grouped by my custom field (code for deliverable).

So my table columns go:
-Deliverable name (custom task field - group criterion)
-Task name
-Baseline start date
-Start date (planned)
-Actual start date
-Computed flag (green/red) depending whether the milestone is on time
compared to baseline.

Since the view uses a group, I have a group header line that contains my
group field (here: Deliverable name) + min(dates in the group) in each date
column for the group header line. Of course I nedd MAX(date) in the group
headerinstead of MIN(date).

Any idea how to do this?
I'll try to show End dates instead (which are the same as start date since I
am displaying milestones) but I doubt this would change anything.
Thanks in advance for your help!

Renaud Duisit -- Project Manager - MCP
 
R

Renaud Duisit

Ok here is the solution for those interested:

Start dates do rollup as Min(StartDate)
Finish dates do rollup as Max(FinishDate)

So as I was dealing with milestones (i.e. start=finish) then I solved my
problem by flipping all date columns to from Start to Finish.
Cool!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top