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

Calculate difference between actual completion and custom form field?

  • May 10, 2022
  • 3 replies
  • 1085 views

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.
    Best answer by Heather_Kulbacki

    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})

    3 replies

    Heather_Kulbacki
    Community Advisor
    Heather_KulbackiCommunity AdvisorAccepted solution
    Community Advisor
    May 16, 2022

    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})

    RandyRoberts
    Community Advisor
    RandyRobertsCommunity Advisor
    Community Advisor
    May 16, 2022

    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?

    Heather_Kulbacki
    Community Advisor
    Heather_KulbackiCommunity Advisor
    Community Advisor
    May 16, 2022

    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.

    G
    GBADAd
    Level 2
    May 23, 2022

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

    Heather_Kulbacki
    Community Advisor
    Heather_KulbackiCommunity Advisor
    Community Advisor
    May 23, 2022

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

      Terms & ConditionsAccessibility statement

      Loading footer...