WEEKDAYDIFF values not populating when comparing project default baseline start dates to go-live task default baseline completion date

[AndreaSt1]

I have a task report built that is correctly showing me two date columns. I want to compare these 2 dates using WEEKDAYDIFF. These are standard fields and values but the valuefield has been customized with text mode.

• Column 1 - Default baseline planned start date for the project
  

  • displayname=Project Baseline Planned Start Date
    
    querysort=project:plannedStartDate
    
    valuefield=project:defaultBaseline:plannedStartDate
    
    valueformat=atDate

• Column 2 - Baseline completion date for the go-live task 

• displayname=Baseline Target Go-Live
  
  linkedname=defaultBaselineTask
  
  namekey=view.relatedcolumn
  
  namekeyargkey.0=defaultBaselineTask
  
  namekeyargkey.1=plannedCompletionDate
  
  querysort=defaultBaselineTask:plannedCompletionDate
  
  valuefield=defaultBaselineTask:plannedCompletionDate
  
  valueformat=atDate

Trying to calculate the difference between these two dates on a Task report using these column details in a "Week Day Difference" column.

• displayname=Week Day Difference
  
  valueexpression=WEEKDAYDIFF({project:defaultBaseline:plannedStartDate},{defaultBaseline:plannedCompletionDate})
  
  valueformat=HTML

Trying to see how long the duration should have been when the project was created/baselines were taken - Project start to go-live task completion . I have read forums and guides but cannot figure out why this is showing up with no data. 

Screenshot of my report with the columns showing values is attached

[AndreaSt1]

Really hope I don't have to create custom fields and add it to all my forms to make this calculation work since these are standard fields. Also tried doing this and had trouble getting values to populate as some link to tasks to generate the date, and some link to projects. 

[AndreaSt1]

[ScottMo1 · Accepted solution]

Hi Andrea,

I think you need to change your value expression to look something like this:

valueexpression=WEEKDAYDIFF({defaultBaselineTask}.{plannedStartDate},{defaultBaselineTask}.{plannedCompletionDate})

I had a similar issue with Baseline Calculations until it was realized it had to be {defaultBaselineTask}.{plannedCompletionDate}    The "." between the Baseline and Planned Completion was my issue - now my report works great.

Hope this works!!!

Scott

[Kurt_Jones]

Scott's response should be spot on with a minor tweak since you're doing compare between project baseline and task baseline you'll need, I can't remember exact syntax, see which one works:

valueexpression=WEEKDAYDIFF({project}.{defaultBaseline}.{plannedStartDate},{defaultBaselineTask}.{plannedCompletionDate})

valueexpression=WEEKDAYDIFF({defaultBaselineProject}.{plannedStartDate},{defaultBaselineTask}.{plannedCompletionDate})

[kautuk_sahni]

@AndreaSt1 Just checking in! Were you able to get this resolved? If you found your own solution, sharing the details would be a big help to others who might face the same issue later on. And if one of the replies here helped, whether it fully solved the problem or simply pointed you in the right direction, marking it as accepted makes it much easier for future readers to find. Thanks again for helping close the loop and contributing to the community!