Workfront Planning: sum of array elements | Community
Skip to main content
P
PiotrBan
Level 2
March 11, 2025
Solved

Workfront Planning: sum of array elements

  • March 11, 2025
  • 1 reply
  • 440 views

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!

Best answer by Madalyn_Destafney

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.

1 reply

Madalyn_Destafney
Community Advisor
Madalyn_DestafneyCommunity AdvisorAccepted solution
Community Advisor
June 30, 2025

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.

If this helped you, please mark correct to help others : )
P
PiotrBanAuthor
Level 2
July 1, 2025

Hi @madalyn_destafney thank you!

Indeed, it solves my problem!!

Thanks a lot for letting me know!

Terms & ConditionsAccessibility statement

Loading footer...