In a "note" report I'm trying to calculate the variance between Pln Comp Date (Planned Completion Date) - ActComp Date (Actual Completion Date), but the calculation is not working. What am I missing? displayname=Pln Comp Date linkedname=task namekey=view.relatedcolumn namekeyargkey.0=task namekeyargkey.1=plannedCompletionDate querysort=task:plannedCompletionDate textmode=true valuefield=task:plannedCompletionDate valueformat=atDate valuefield=task:actualCompletionDate valueformat=atDate linkedname=task displayname=Act Comp Date namekey=view.relatedcolumn textmode=true namekeyargkey.0=task namekeyargkey.1=actualCompletionDate querysort=task:actualCompletionDate Start descriptionkey=task.plannedcompletiondate displayname=Actual Completion Variance linkedname=direct listsort=atDateAsAtDate(task.plannedCompletionDate) namekey=task.plannedcompletiondate.abbr querysort=task.plannedCompletionDate shortview=false stretch=100 styledef.case.0.comparison.attribute=css styledef.case.0.comparison.isrowcase=false styledef.case.0.comparison.leftmethod=atDateAsAtDate(task.plannedCompletionDate) styledef.case.0.comparison.lefttext=task.plannedCompletionDate 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({task:actualCompletionDate},{task:plannedCompletionDate})) valueformat=HTML width=75
