Expand my Community achievements bar.

Latest Community Ideas Review is Out: Discover What’s New and What to Expect!
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