Calculate task completion to project completion

[ChristinaPi4]

I have a project report I am trying to calculate the actual start date of a certain task to the project actual completion. 

I have this code started:

displayname=Actual Task Start to Job Completion
listdelimiter=
listmethod=nested(tasks).lists
textmode=true
type=iterate
valueexpression=WEEKDAYDIFF({task}.{name}="Revisions".{actualStartDate},{project}.{actualCompletionDate})
valueformat=HTML

[NicholeVargas]

@ChristinaPi4 If you started with a Task Report that filtered for Task Name > Contains > Revisions, you wouldn't have to reference text mode collections. Instead, your text mode column would just be a basic valueexpression: 

displayname=Actual Task Start to Job Completion
valuefield=HTML
valueexpression=WEEKDAYDIFF({actualStartDate},{project}.{actualCompletionDate})

 However, if you are needing to use a Project Report, the your expression would look like this:

displayname=Actual Task Start to Job Completion
listdelimiter=
listmethod=nested(tasks).lists
textmode=true
type=iterate
valueexpression=IF({name}="Revisions",WEEKDAYDIFF({actualStartDate},{project}.{actualCompletionDate}))
valueformat=HTML

[ChristinaPi4]

@NicholeVargas Thanks Nicole! I had it working in a task report but the team wanted it in a project report.

Is there a possibility if the task contains the word "revisions" incase the task name isn't just "revisions"?

Thanks!

Christina

[NicholeVargas · Accepted solution]

@ChristinaPi4 of course - you can use the CONTAINS expression instead:

displayname=Actual Task Start to Job Completion
listdelimiter=
listmethod=nested(tasks).lists
textmode=true
type=iterate
valueexpression=IF(CONTAINS("revisions",{name}),WEEKDAYDIFF({actualStartDate},{project}.{actualCompletionDate}))
valueformat=HTML

[ChristinaPi4]

Thanks for that!

I just needed to capitalize the task name then it worked. I will note next time it is case sensitive. 

Thanks so much!

[Manjug]

I have a project report I am trying to calculate the Week Day difference of two different tasks Planned Completion Date. Certain tasks name contains Deploys and Certain tasks name contains Receive Opt Out File .

I have this code started but out put as blank and could you please help me on this.

valueexpression=WEEKDAYDIFF(IF(CONTAINS("Receive Opt Out File",{name}),CONCAT({plannedCompletionDate})),IF(CONTAINS("Deploys",{name}),CONCAT({plannedCompletionDate})))
listdelimiter=<p>
listmethod=nested(tasks).lists
valueformat=HTML
displayname=Weekday Difference
textmode=true
type=iterate

[NicholeVargas]

@Manjug In order to calculate the number of days between two different tasks on a project, you would need to start with a task report.