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

NicholeVargas
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

    M
    ManjunathaG
    August 24, 2024

    @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

     


    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

    Terms & ConditionsAccessibility statement

    Loading footer...