Calculate task completion to project completion | Community
Skip to main content
ChristinaPisell
ChristinaPisell
April 4, 2024
Solved

Calculate task completion to project completion

  • April 4, 2024
  • 1 reply
  • 1664 views

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

Best answer by NicholeVargas

@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

 

1 reply

N
Adobe Employee
NicholeVargasAdobe Employee
Adobe Employee
April 4, 2024

@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
    ChristinaPisellAuthor
    April 5, 2024

    @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

    N
    Adobe Employee
    NicholeVargasAdobe Employee
    Adobe Employee
    April 16, 2025

    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

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

    Terms & ConditionsAccessibility statement

    Loading footer...