Looking for help on txt mode for a calculated duration variance on a report at the project level | Community
Skip to main content
S
SheilaMi1
Level 2
May 16, 2017
Question

Looking for help on txt mode for a calculated duration variance on a report at the project level

  • May 16, 2017
  • 3 replies
  • 655 views
Looking for help on txt mode for a calculated duration variance on a report at the project level. I need to know the duration variance between what was approved (baseline) and what is planned. I am able to get the txt mode calculation at the task level but completely stuck at the project level. Any suggested tweaks would be greatly appreciated! Here is the txt as I have it right now: description=Duration Variance displayname=Planned Duration Variance to Baseline durationunitfield=durationUnit.value linkedname=direct listsort=intAsInt(durationMinutes) name=Duration Variance namekey=duration querysort=project:durationMinutes shortview=false stretch=100 textmode=true valueexpression=((SUB{project:durationMinutes},{defaultBaseline}.{project:durationMinutes})/480," Days") valuefield=project:durationMinutes valueformat=compound#M:D viewalias=project:duration width=100
    This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

    3 replies

    N
    NRYNR
    Level 10
    May 18, 2017
    Sheila, have you considered using the DATEDIFF, WEEKDAYDIFF, or WORKMINUTESDIFF functions? Example: valueexpression=ABS(WEEKDAYDIFF({entryDate},{actualCompletionDate}))
    S
    SheilaMi1Author
    Level 2
    May 25, 2017
    Thank you for the suggestion! I may use that calc functionality in the future. I was successful in getting the txt I needed. Sharing in case someone else needs/wants. displayname=Planned Duration Variance to Baseline linkedname=direct namekey=duration querysort=durationMinutes textmode=true valueexpression=CONCAT(ROUND(({project}.{durationMinutes}-{project}.{defaultBaseline}.{durationMinutes})/480),' Days') valuefield=durationMinutes valueformat=compound#M:D viewalias=duration
    G
    GregBe1
    Level 9
    May 25, 2017
    Thanks Shiela. BTW, it didn't work for me initially, so in the valueexpression I took out the reference to {project} since it's at the project level and it worked. Mine looks like this (in case anyone needs it): valueexpression=CONCAT(ROUND(({durationMinutes}-{defaultBaseline}.{durationMinutes})/480),' Days') Not sure why it didn't work for me, but now it does.
    Terms & ConditionsAccessibility statement

    Loading footer...