Need to show milestone duration in collection report

[Jcosta16]

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

[KristenS_WF]

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

[KellieGardner · Accepted solution]

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))