Calculate the sum of numbers in a column in a report

Forum|Forum|3 years ago
May 2, 2022
2 replies
1679 views

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

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

Best answer by skyehansen

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

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

O

OliviaMiAuthor

Level 4

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!