Skip to main content
Sbhuta
Level 3
June 9, 2020
Pergunta

Converting Project Duration from days to weeks

  • June 9, 2020
  • 1 comentário
  • 552 Visualizações

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

    Este tópico foi fechado para respostas.

    1 comentário

    SbhutaAutor
    Level 3
    June 9, 2020

    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

    Condições do fórumAccessibility statement

    Loading footer...