Baseline Task Planned Completion Date Variance to Planned Completion Date | Community
Skip to main content
Tammy_Hall-Johnson
Tammy_Hall-Johnson
Level 2
August 4, 2021
Question

Baseline Task Planned Completion Date Variance to Planned Completion Date

  • August 4, 2021
  • 1 reply
  • 541 views

UGH! I am sure there is an easy way to build this, but in a task report or a task view in a project, I want to see the PCD and the Default Baseline PCD side by side with a calculation that shows me the variance. I have this code for the variance, but it's not working... I am beating my head against the wall! Help! :)

descriptionkey=plannedcompletiondate

displayname=PCD Var

linkedname=direct

listsort=atDateAsAtDate(plannedCompletionDate)

querysort=plannedCompletionDate

shortview=false

stretch=0

styledef.case.0.comparison.attribute=css

styledef.case.0.comparison.isrowcase=false

styledef.case.0.comparison.leftmethod=atDateAsAtDate(plannedCompletionDate)

styledef.case.0.comparison.lefttext=plannedStartDate

styledef.case.0.comparison.operator=notnull

styledef.case.0.comparison.operatortype=date

styledef.case.0.comparison.righttext=

styledef.case.0.comparison.trueproperty.0.name=bgcolor

styledef.case.0.comparison.trueproperty.0.value=E1E1E1

styledef.case.0.comparison.truetext=

styledef.case.0.comparison.usefield=false

textmode=true

valueexpression=ROUND(DATEDIFF({plannedCompletionDate},{defaultBaselineTask:plannedCompletionDate}),2)

valueformat=HTML

width=75

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

1 reply

R
Community Advisor
Richard_Le_Community Advisor
Community Advisor
August 4, 2021

Hi Tammy,

It looks like there's an error in your syntax. Try updating your value expression to the following instead:

valueexpression=ROUND(DATEDIFF({plannedCompletionDate},{defaultBaselineTask}.{plannedCompletionDate}),2)

Best Regards,

Rich.

Terms & ConditionsAccessibility statement

Loading footer...