This conversation has been locked due to inactivity. Please create a new post.
Interested in getting an Adobe Workfront certification? Don't miss our AMA on June 10th, where our experts will be available to answer any questions you may have about getting certified!
Help with report calculation
Hello,
I'm trying to create a calculated field on a task level report adding the handoff date + the duration with the answer being the date and time of day. I cannot use projected completion date since it moves each day the task is not started.
This is what I have so far, however, the calculation is not taking into account the duration if there's a decimal involved. We use decimals for duration - 1.5 days, .5 days.
valueexpression=ADDWEEKDAYS({handoffDate},({durationMinutes}/450)) Note: 450 is the amount of minutes in a work week as we are on 7.5 hr days)
textmode=true
valueformat=longAtDate
displayname=Task Due Date
Related Conversations
