Calculate difference between actual completion and custom form field? | Community
Skip to main content
Kasey-Gagne
Level 5
May 10, 2022 2:03 PM UTC
Solved

Calculate difference between actual completion and custom form field?

Is it possible to calculate the difference between a custom form date field and the project's actual completion date in a report?

For example, we have an "Ideal Due Date" field that we capture on our request forms and would like to report on the difference between what the requestor's ideal due date and when the project was actually completed on.

    This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
    Heather_Kulbacki
    Heather_KulbackiAccepted solution
    Level 2
    May 16, 2022 2:47 PM UTC

    If you're looking for the difference in the number of workdays between the two dates, this should help: View: display the result of a calculation between two fields in a column

    So on a project report, I believe your valueexpression would look something like this: valueexpression=WEEKDAYDIFF({convertedOpTask}.{Ideal Due Date},{actualCompletionDate})

    View reply

    5 replies

    GBADAd
    Level 2
    May 23, 2022 12:05 AM UTC

    This is terrific thank you - is there a calculation that considers public holidays?

    Translate
    Heather_Kulbacki
    Heather_Kulbacki
    Level 2
    May 23, 2022 12:38 PM UTC

    If you include those holidays in your Schedule Exceptions they will figure into your calculations.

    Translate
      RandyRoberts
      RandyRoberts
      New Participant
      May 16, 2022 5:15 PM UTC

      Make sure that "DE:Ideal Due Date "is in date format and not text!

      @Heather Kulbacki‚ , would that still work without the "DE:" in front of the custom field?

      Translate
      Heather_Kulbacki
      Heather_Kulbacki
      Level 2
      May 16, 2022 5:49 PM UTC

      I honestly can't remember if the "DE:" is needed or not - sounds like she's looking to do this in a custom column, not a field and I couldn't find a column where I had done any calculation between 2 dates - I know I've done them, just couldn't find one.

      Great reminder on the format of the "Ideal Due Date" field - I forget that every time and usually have to create a new field with the correct format.

      Translate
      Heather_Kulbacki
      Heather_KulbackiAccepted solution
      Level 2
      May 16, 2022 2:47 PM UTC

      If you're looking for the difference in the number of workdays between the two dates, this should help: View: display the result of a calculation between two fields in a column

      So on a project report, I believe your valueexpression would look something like this: valueexpression=WEEKDAYDIFF({convertedOpTask}.{Ideal Due Date},{actualCompletionDate})

      Translate
      Terms & ConditionsAccessibility statement

      Loading footer...