Ideas for how to build a report | Community
Skip to main content
N
NaushinWa
Level 3
December 18, 2020
Question

Ideas for how to build a report

  • December 18, 2020
  • 1 reply
  • 431 views

Hello everyone, wondering if anyone has ideas on how to build this report... I want to see a delta between my planned dates, projected dates, and end dates. so Planned vs Projected delta, Planned vs Actual Delta for dates. This report will then show us tasks that we're frequently either starting late or ending late. I am not too comfortable in text mode so I am not even sure where to begin.

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

    1 reply

    R
    Community Advisor
    Richard_Le_Community Advisor
    Community Advisor
    December 18, 2020

    Hi Naushin,

    You can build a calculated column in your report view to achieve this. Simply go to your report builder and in the column (view) settings, add a column and convert to text mode. Then paste the following code into the text mode builder:

    This code will work out the difference in weekdays between the planned completion date and the projected completion date:

    displayname=Planned Projected Delta

    textmode=true

    valueexpression=WEEKDAYDIFF({plannedCompletionDate},{projectedCompletionDate})

    valueformat=int

    This code will work out the difference in weekdays between the planned completion date and the actual completion date:

    displayname=Planned Actual Delta

    textmode=true

    valueexpression=WEEKDAYDIFF({plannedCompletionDate},{actualCompletionDate})

    valueformat=int

    The above examples are obviously working out the difference between completion date fields. You could also do the same for start date fields. Simple change the variable names in the code from 'plannedCompletion . . .' to 'plannedStart . . .'

    I hope that makes sense! Please shout if anything is unclear.

    Best Regards,

    Rich.

      Terms & ConditionsAccessibility statement

      Loading footer...