I am in the hour view of a project and I am attempting to make a new view which has three columns
1. Calculated hours per day for the task
2. Planned hours for the task (task: Work)
3. Duration for the task (showing in days)
The calculation I wish to do is planned hours/duration in days = planned hours/day
Here is the text mode view of the calculated hours per day
displayname=Calculated Hours/Day
linkedname=task
namekey=view.relatedcolumn
namekeyargkey.0=task
namekeyargkey.1=work
querysort=task:work
textmode=true
valueexpression=({workRequired},{plannedDuration})
valuefield=work
valueformat=doubleAsDouble
However the calculated column is blank
Do I have a mistake in my text mode?
Solved! Go to Solution.
Views
Replies
Total Likes
Hi Bill,
here is what I was able to get to work. Since you are on an hour report you will need the {task}.
My test project task had 16 hours with a duration of 5 days, giving me 3.2 hours / day.
valueexpression=({task}.{workRequired}/60) / ({task}.{plannedDurationMinutes}/480)
textmode=true
valueformat=HTML
displayname=Calculated Hours/Day
Views
Replies
Total Likes
Hi Bill,
here is what I was able to get to work. Since you are on an hour report you will need the {task}.
My test project task had 16 hours with a duration of 5 days, giving me 3.2 hours / day.
valueexpression=({task}.{workRequired}/60) / ({task}.{plannedDurationMinutes}/480)
textmode=true
valueformat=HTML
displayname=Calculated Hours/Day
Views
Replies
Total Likes
Thank you for the text - it worked just fine
Views
Replies
Total Likes
Views
Likes
Replies