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
Solved! Go to Solution.
Topics help categorize Community content and increase your ability to discover relevant content.
Views
Replies
Total Likes
@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
Views
Replies
Total Likes
@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
@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
Views
Replies
Total Likes
@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
Views
Replies
Total Likes
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!
Views
Replies
Total Likes
Views
Likes
Replies
Views
Likes
Replies