Workfront Planning: sum of array elements

[PiotrBan]

Hi All!

Do you know if there's a way to sum all the elements of the array in Workfront Planning?

The current scenario I follow is:

- in the record type A i have the planned activities where we calculated the required effort with some formula

- in the record type B I want to display the sum of the efforts but while adding the connected field, I can't aggregate it by SUM (probably because it's created by formula). It only displays as an array of values.

Therefore my question: how to easily summarize the array elements?

Many thanks for all the ideas!

[Madalyn_Destafney · Accepted solution]

Hi there, I realize your post is fairly old, but in case you haven't gotten help - I'm wondering if this enhancement related to formula fields that was release 6.26.25 answers this. The below snippet came from Q3's release notes.

New aggregating functionality for formula fields

NOTE

• Preview: June 26, 2025
• Production for everyone: June 26, 2025

Now, when you connect record types and bring in a formula field as a lookup, you can apply the aggregate functions (SUM, AVERAGE, MIN, MAX, etc) depending on the formula field’s format. For example, if the formula field is numeric, you can use functions like SUM or AVG; if the formula field is formatted as text, aggregate functions like SUM will not apply. Previously, when connecting record types and bringing in lookup fields from the connected records, you could apply aggregate functions only to regular fields, but not to formula fields.

[PiotrBan]

Hi @Madalyn_Destafney thank you!

Indeed, it solves my problem!!

Thanks a lot for letting me know!