Expand my Community achievements bar.

Latest Community Ideas Review is Out: Discover What’s New and What to Expect!

Converting Project Duration from days to weeks

Avatar

Level 3

I would like to create a calculated field to convert the project duration field from days into weeks? Any help will be appreciated.

Topics

Topics help categorize Community content and increase your ability to discover relevant content.

1 Reply

Avatar

Level 3

Please close this request. I found the answer below from one of the posts:

Thanks so much for responding. Unfortunately - it doesn't seem to like the format statement. Each time I try to add valueformat=compound#M:D The system erases it. displayname=Duration in Weeks durationunitfield=durationUnit.value linkedname=direct namekey=duration querysort=durationMinutes textmode=true valueexpression=CONCAT(ROUND(DIV({durationMinutes},60,8,5),1)," Weeks") valuefield=durationMinutes valueformat=compound viewalias=duration Michelle Banks Christus Health