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!