Expand my Community achievements bar.

Join us LIVE in San Francisco on November 14th for Experience Makers The Skill Exchange. Don't miss out on this free learning event!
SOLVED

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

Avatar

Level 3

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

BillPe_1-1693341064566.png

BillPe_0-1693340997549.png

Do I have a mistake in my text mode?

 

 

1 Accepted Solution

Avatar

Correct answer by
Level 3

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

View solution in original post

2 Replies

Avatar

Correct answer by
Level 3

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

Avatar

Level 3

Thank you for the text - it worked just fine