Help with calculated fields

5 replies
1085 views
Translate

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.

B

BenettaPe

Level 9

The two functions you will use is PROD and SUM

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

Translate

A

AdinaPi1

Level 9

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.

Translate

T

TimBr1Author

Level 4

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?

Translate

JoeSalas

Level 3

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

Translate

A

AdinaPi1

Level 9

What you have works:

(Field1+Field2)*Field3

Make sure all 4 fields are Number format

Save the first 3 fields before creating the calculation.