Help with calculated fields

[TimBr1]

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?

[AdinaPi1]

What you have works:

(Field1+Field2)*Field3

Make sure all 4 fields are Number format

Save the first 3 fields before creating the calculation.

[TimBr1]

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?

[joes68374352]

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%2FAdministratio...

[AdinaPi1]

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.

[BenettaPe]

The two functions you will use is PROD and SUM

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