Calculate the sum of numbers in a column in a report

[OliviaMi]

Hi All - I have a custom number field that shows "Number of assets requested" by project. I want to show the TOTAL number of assets requested for all projects in that portfolio. Can I create a calculated field to show that number?

Thank you!

Olivia

[skyehansen · Accepted solution]

hi Olivia, that's not a calculated field (nor can one be created), but you can use the existing functionality to summarize a column, identical to the answer I posted here: https://one.workfront.com/s/question/0D54X00007bFOZ4SAO/sum-of-figures-in-a-column

[OliviaMi]

Ah darn, I was hoping to be able to show one number, like they show in the KPIs learning path for metrics - https://one.workfront.com/s/learningpath3/kpi-dashboards-MCA7GUNW2VD5FGBA7XVSS42XEQKI ---- perhaps a WF enhancement down the line :) Thanks for your help!

[RandyRoberts]

This looks very closely related to this thread.

https://one.workfront.com/s/question/0D54X00007bFOZ4SAO/sum-of-figures-in-a-column

[OliviaMi]

Thank you Randy!