Template Duration vs. Project Duration rollup variance | Community
Skip to main content
Nikki_Clemmons
Nikki_Clemmons
Level 2
January 6, 2023
Solved

Template Duration vs. Project Duration rollup variance

  • January 6, 2023
  • 2 replies
  • 845 views

Hi,

I am trying to do a variance between the template duration and the project actual duration. I have used the formula below and some others but nothing is working. This works on another report I have with a custom form field on a task vs. planned task work required.

 

displayname=Variance Plan vs Time Completed

textmode=true

valueexpression=SUB({template:durationMinutes},{actualDurationMinutes})

valueformat=compound#M:D

 

Thanks!

 

    This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
    Best answer by RichLeek

    Hi Nikki,

     

    Try the below instead:

     

    valueexpression=SUB({template}.{durationMinutes},{actualDurationMinutes})
textmode=true
valueformat=compound#M:D
displayname=Variance Plan vs Time Completed

    There was an error in your syntax. "template" and "durationMinutes" need to be in separate curly brackets.

     

    Best Regards,

    Rich. 

    2 replies

    R
    RichLeekAccepted solution
    New Member
    January 6, 2023

    Hi Nikki,

     

    Try the below instead:

     

    valueexpression=SUB({template}.{durationMinutes},{actualDurationMinutes})
textmode=true
valueformat=compound#M:D
displayname=Variance Plan vs Time Completed

    There was an error in your syntax. "template" and "durationMinutes" need to be in separate curly brackets.

     

    Best Regards,

    Rich. 

      Nikki_Clemmons
      Nikki_ClemmonsAuthor
      Level 2
      January 7, 2023

      Thank you so much! That worked! and I added minutesAsDaysString so now I have days difference. 

      displayname=Variance Plan vs Time Completed
      textmode=true
      valueexpression=SUB({template}.{durationMinutes},{actualDurationMinutes})
      valueformat=minutesAsDaysString

        Kundanism
        Kundanism
        Level 10
        January 9, 2023

        @nikki_clemmons 

        Just curious, where did you used this text mode, is it in project view or template view as a column?

        Thanks in advance.

        Mvh

        Kundan.

        Terms & ConditionsAccessibility statement

        Loading footer...