Baseline Task Planned Completion Date Variance to Planned Completion Date

[Tammy_Hall-Johnson]

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

[Richard_Le_]

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.