Expand my Community achievements bar.

Do you have questions about the migration to Adobe Business Platform? Come join our upcoming coffee break and ask away!

Task Report calculated field question

Avatar

Level 1

Hello, I'm looking to create a calculated field on a task report.

 

I would like the calculation to be task handoff date + task duration and the result to show in date and time format.

 

 I cant seem to find a field that gives me this without the dates moving to the next business day if a task is late (projected completion date, etc.)

2 Replies

Avatar

Level 1

I came up with the below calculation which seems to work, but when my duration has a decimal (.5 days, 1.5 days) the calculation doesn't notice the .5, it rounds down to day. 

Example:

Handoff date - 12/19 10 am

Duration - 1.5 days

Calculation -  12/20 10 am

 

Thoughts on how I get the system to notice the decimal??

 

valueexpression=ADDWEEKDAYS({handoffDate},({plannedDurationMinutes}/480))
textmode=true
valueformat=longAtDate
displayname=Due Date