Need to show milestone duration in collection report

Question

Hi community! Trying to show a specific milestone duration (in days) in a collections report. My current text mode below just returns minutes, and I know the valueformat needs to be updated to something similar to valueformat=compound#M:D but I'm not sure where to do it in the value expression. Additionally, I'd love to not do a datediff of milestone's planned completion and planned start date if I can avoid it. Thanks!

displayname=CREATIVE DEVELOPMENT PLANNED DURATION
listdelimiter=<p>
listmethod=nested(tasks).lists
textmode=true
type=iterate
valueexpression=IF({milestone}.{name}="CREATIVE DEVELOPMENT",{durationMinutes})
valueformat=html

listmethod=nested(tasks).liststextmode=truetype=iteratevalueexpression=IF({milestone}.{name}="CREATIVE DEVELOPMENT",{durationMinutes})valueformat=html

KellieGardner · Accepted Answer

You might also need to do some rounding depending on how the durations are setup as well. Mine always come back with decimals.

Like Kristen said, you basically you need to divide the duration minutes by how many minutes are in your schedule from the setup in the back end. (our instance is 7.5 hours on our schedule so we would divide by 450 instead of 480).

valueexpression=IF({milestone}.{name}="CREATIVE DEVELOPMENT",ROUND(DIV({durationMinutes},XXX),0))

KristenS_WF · Answer

Assuming you've got an 8-hour workday, try replacing {durationMinutes} with DIV({durationMinutes},480) in your expression.

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded