Trying to create a calculated value column using values from two other columns in a Workfront View and it is not working

Question

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?

ajdifonzo · Accepted Answer

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

Registrati

Accesso al social

Accedi alla community

Accesso al social