Help with report calculation | Community
Skip to main content
Level 2
February 14, 2023
Question

Help with report calculation

  • February 14, 2023
  • 0 replies
  • 411 views

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

 

 

 

 

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.