Template Duration vs. Project Duration rollup variance

[Nikki_Clemmons]

Hi,

I am trying to do a variance between the template duration and the project actual duration. I have used the formula below and some others but nothing is working. This works on another report I have with a custom form field on a task vs. planned task work required.

displayname=Variance Plan vs Time Completed

textmode=true

valueexpression=SUB({template:durationMinutes},{actualDurationMinutes})

valueformat=compound#M:D

Thanks!

[RichLeek · Accepted solution]

Hi Nikki,

Try the below instead:

valueexpression=SUB({template}.{durationMinutes},{actualDurationMinutes})
textmode=true
valueformat=compound#M:D
displayname=Variance Plan vs Time Completed

There was an error in your syntax. "template" and "durationMinutes" need to be in separate curly brackets.

Best Regards,

Rich. 

[Nikki_Clemmons]

Thank you so much! That worked! and I added minutesAsDaysString so now I have days difference. 

displayname=Variance Plan vs Time Completed
textmode=true
valueexpression=SUB({template}.{durationMinutes},{actualDurationMinutes})
valueformat=minutesAsDaysString

[Kundanism]

@Nikki_Clemmons 

Just curious, where did you used this text mode, is it in project view or template view as a column?

Thanks in advance.

Mvh

Kundan.