Days rom start to finish

[Fadius]

OK, I have a and in the table is names and workitems with dates.

Groupiong is by Name, then work item. One work item type is Setup. I only need the received date from this to pass through to all other work items as I need to calculate days from received on the setup work item to the complete date on the other work items.

I am not able to get this to work or to pass this date down through the other work items. Can anyone help?

Example:

Name Work_Item_Type received complete
John Setup 01/01/11 01/14/11
John Item 1 Null 02/21/11
John Item 2 Null 03/01/11
John Item 3 Null 03/04/11
Mary Setup 02/11/11 02/15/11
Mary Item 1 Null 02/21/11


I only need the received date from Setup Work Item for John and need it to tranfer to the other Work Items for John. Same with Mary.

 

[lbass]

If there is only one setup workitem per name, then create a formula like this:

//{@setupdt}:
if {table.workitemtype} = "Setup" then
{table.received}

Then you can use a formula like this to calculate the days (place it in the detail section):

datediff("d",maximum({@setupdt},{table.name}),{table.complete})

This assumes you have inserted a group on {table.name}. You can suppress the group header and footer if you wish.

-LB