Expand my Community achievements bar.

Help with report calculation


Level 1



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)
displayname=Task Due Date






0 Replies