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!
Solved! Go to 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.
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.
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
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.
Views
Replies
Total Likes
Views
Like
Replies
Views
Likes
Replies
Views
Likes
Replies