Calculate task completion to project completion

[ChristinaPisell]

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]

@ChristinaPisell 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

[ChristinaPisell]

@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]

@ChristinaPisell 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

[ChristinaPisell]

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. 

[DeepaMa1]

Hi @NicholeVargas,

I have created a task report displaying only 3 tasks that I need to show from a project. Then, I need to do below calculation on task completion dates of the 3 tasks. Is it possible to do it in WF without fusion?

IF [CoC Received] > [FEDV Data Final] THEN

     [CoC Received] - [CIS Submission]

ELSE

     [FEDV Data Final] - [CIS Submission]

ENDIF

Thanks,

Deepa M

[NicholeVargas]

@DeepaMa1 Are these custom fields set up as date, number, or text fields? Asking because if you are wanting to use a subtraction calculation, they would need to be set up as number fields. If they are date fields, are you wanting to look at the date difference between the two? Any additional context would be super helpful! 

[DeepaMa1]

@NicholeVargas These are not custom fields of the form. I am looking for date difference between completion date of tasks of a project.