Help with calculated fields | Community
Skip to main content
T
TimBr1
Level 4
September 1, 2020
Question

Help with calculated fields

  • September 1, 2020
  • 4 replies
  • 1089 views

I hope this one is easy. I am looking to add two custom fields, and then multiple that sum by another custom field.

Overall:

(field 1+field 2)*field 3

Thoughts?

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

    4 replies

    A
    AdinaPi1
    Level 9
    September 1, 2020

    What you have works:

    (Field1+Field2)*Field3

    Make sure all 4 fields are Number format

    Save the first 3 fields before creating the calculation.

    T
    TimBr1Author
    Level 4
    September 2, 2020

    Uh, still having trouble, and I confirmed all of these details. Are there any tricks I could be forgetting to make it work? Spacing between things, or other little things?

    JoeSalas
    JoeSalas
    Level 3
    September 2, 2020

    If you are comparing a custom field, use DE:Actual Name of the Field for the name field you are comparing with the first field.

    Note:

    If you manually enter the name of a custom field by the same name as a Workfront native field, you must precede it in the calculation by "DE:" and surround it by curly brackets so that Workfront knows that you are referencing the custom field.

    https://one.workfront.com/s/document-item?bundleId=workfront-classic&topicId=Content%2FAdministration_and_Setup%2FCustomize_Workfront%2FCreate_manage_Custom_Forms%2Fadd-calculated-data-to-custom-form.html

    A
    AdinaPi1
    Level 9
    September 2, 2020

    Can you provide a screenshot of what you have or actual names of the fields? If you have special characters in your field names, that might make a difference.

    B
    BenettaPe
    Level 9
    September 2, 2020

    The two functions you will use is PROD and SUM

    (PROD(SUM(DE:field1, DE:field2)DE:field3))

      Terms & ConditionsAccessibility statement

      Loading footer...