I would like to create a calculated field to convert the project duration field from days into weeks? Any help will be appreciated.
Topics help categorize Community content and increase your ability to discover relevant content.
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
Views
Replies
Total Likes