# Showing sum of project's numeric field (costs etc.) in Portfolios **URL:** \ **Category:** Product Ideas\ **Tags:** portfolios, custom-fields, launched\ **Created:** [11 December 2020 15:53 UTC](https://forum.asana.com/t/showing-sum-of-projects-numeric-field-costs-etc-in-portfolios/102939 "2020-12-11T15:53:47Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![Vanessa\_Künstler](https://sea2.discourse-cdn.com/asana/user_avatar/forum.asana.com/vanessa_k%C3%BCnstler/32/66682_2.png) [@Vanessa\_Künstler](https://forum.asana.com/u/Vanessa_K%C3%BCnstler)\ **Post date:** [11 December 2020 15:53 UTC](https://forum.asana.com/t/showing-sum-of-projects-numeric-field-costs-etc-in-portfolios/102939/1 "2020-12-11T15:53:47Z")
Hi, we have created some custom fields in our projects, like estimated costs, actual costs, benefit etc. We have also added these fields to our portfolio overview, but we do not see the totals. It seems like it has to be put in manually. Is there a way to automatically show totals of custom fields (e.g. total sum of costs) in the portfolio overview? Thank you! Vanessa ---
**Author:** ![Bastien\_Siebman](https://sea2.discourse-cdn.com/asana/user_avatar/forum.asana.com/bastien_siebman/32/172354_2.png) [@Bastien\_Siebman](https://forum.asana.com/u/Bastien_Siebman)\ **Post date:** [12 December 2020 08:04 UTC](https://forum.asana.com/t/showing-sum-of-projects-numeric-field-costs-etc-in-portfolios/102939/2 "2020-12-12T08:04:28Z")
Hi, If I am not mistaken, custom fields at the project level and at portfolio levels are two different things and are not related indeed. I don’t know if Asana has plan to link them on day… @Marie @Emily_Roman any input? ---
**Author:** ![LEGGO](https://sea2.discourse-cdn.com/asana/user_avatar/forum.asana.com/leggo/32/94022_2.png) [@LEGGO](https://forum.asana.com/u/LEGGO)\ **Post date:** [12 December 2020 16:00 UTC](https://forum.asana.com/t/showing-sum-of-projects-numeric-field-costs-etc-in-portfolios/102939/3 "2020-12-12T16:00:27Z")
@Bastien_Siebman Custom Fields are actually global components that can be applied to projects and portfolios all the same. I quite often will use the same global Custom Fields (saved to Org) at both the project and portfolio level. I believe what @Vanessa_Künstler is pointing out is there isn’t a way to see the average/sum of numerical values in custom fields from the portfolio view, like you can in projects across the whole or within sections. I’m hopeful that in the future the Dashboard tab will be available for Portfolios and this would be a great way to see the breakouts you are looking for @Vanessa_Künstler. In the meantime, I would recommend looking into [exporting your Portfolio to a Google Sheet.](https://asana.com/guide/help/premium/portfolios#gl-google-sheets). This creates a dynamic connection and enables you to create a variety of visuals like pivot tables, charts, dashboard widgets, etc. While I, too, would love to see some level of charting like this in Asana it is a fantastic integration that syncs data every hour! ---
**Author:** ![Bastien\_Siebman](https://sea2.discourse-cdn.com/asana/user_avatar/forum.asana.com/bastien_siebman/32/172354_2.png) [@Bastien\_Siebman](https://forum.asana.com/u/Bastien_Siebman)\ **Post date:** [12 December 2020 18:10 UTC](https://forum.asana.com/t/showing-sum-of-projects-numeric-field-costs-etc-in-portfolios/102939/4 "2020-12-12T18:10:43Z")
I do understand they are all “custom fields” you can mix and match. But my belief was that the initial Asana plan was to have portfolio fields (budget, priority…) and project custom fields (stage, minutes…). But that would be cool to have them linked! ---
**Author:** ![LEGGO](https://sea2.discourse-cdn.com/asana/user_avatar/forum.asana.com/leggo/32/94022_2.png) [@LEGGO](https://forum.asana.com/u/LEGGO)\ **Post date:** [12 December 2020 20:07 UTC](https://forum.asana.com/t/showing-sum-of-projects-numeric-field-costs-etc-in-portfolios/102939/5 "2020-12-12T20:07:21Z")
Yeah, I haven’t discovered a handle full of cases where I can use the same custom field at both levels but there are a few. Given that a custom field isn’t dedicated to a project or portfolio (meaning it can be created in one and added to the other), I think it would be great to retain custom field assignments when converting a task to a project. To achieve this you would have to be able to add a project to a Portfolio when converting from a task. ---
**Author:** ![Bastien\_Siebman](https://sea2.discourse-cdn.com/asana/user_avatar/forum.asana.com/bastien_siebman/32/172354_2.png) [@Bastien\_Siebman](https://forum.asana.com/u/Bastien_Siebman)\ **Post date:** [13 December 2020 08:25 UTC](https://forum.asana.com/t/showing-sum-of-projects-numeric-field-costs-etc-in-portfolios/102939/6 "2020-12-13T08:25:46Z")
> [@LEGGO](#): > > Yeah, I haven’t discovered a handle full of cases where I can use the same custom field at both levels but there are a few. Exactly my point yet, but badly articulated in my case. ---
**Author:** ![Emily\_Roman](https://sea2.discourse-cdn.com/asana/user_avatar/forum.asana.com/emily_roman/32/283076_2.png) [@Emily\_Roman](https://forum.asana.com/u/Emily_Roman)\ **Post date:** [14 December 2020 10:31 UTC](https://forum.asana.com/t/showing-sum-of-projects-numeric-field-costs-etc-in-portfolios/102939/7 "2020-12-14T10:31:49Z")
@Vanessa_Künstler I believe your question is similar to this one: [Custom Fields in a Portfolio not populating](https://forum.asana.com/t/custom-fields-in-a-portfolio-not-populating/95228). As it stands, it’s currently not possible to automatically see the total of a number custom field in Portfolio. We don’t have immediate plans to implement this feature but I’ve gone ahead and moved your thread to the product feedback category to allow other customers to support this request 🙂 ---
**Author:** ![Vanessa\_Künstler](https://sea2.discourse-cdn.com/asana/user_avatar/forum.asana.com/vanessa_k%C3%BCnstler/32/66682_2.png) [@Vanessa\_Künstler](https://forum.asana.com/u/Vanessa_K%C3%BCnstler)\ **Post date:** [14 December 2020 15:17 UTC](https://forum.asana.com/t/showing-sum-of-projects-numeric-field-costs-etc-in-portfolios/102939/8 "2020-12-14T15:17:47Z")
Thank you @Emily_Roman, Bastien and Jerod! I have found a work around: I get the total number of the custom field from the project’s dashboard, type that number in manually in my status report. Now the custom field in the portfolio gets automtically populated. It is not ideal to type something in manually but I think it is okay since you should update your projects on a regular basis anyway 😉 Anyhow, I would very much appreciate an automated function in the future 🙂 ---
**Author:** ![Keith\_Guerrette](https://sea2.discourse-cdn.com/asana/user_avatar/forum.asana.com/keith_guerrette/32/57453_2.png) [@Keith\_Guerrette](https://forum.asana.com/u/Keith_Guerrette)\ **Post date:** [2 October 2021 19:39 UTC](https://forum.asana.com/t/showing-sum-of-projects-numeric-field-costs-etc-in-portfolios/102939/9 "2021-10-02T19:39:54Z")
I have to dig into why you don’t support this currently, as it’s yet another example of going _almost_ far enough to allow your users to create better project reporting, but creating a hard stop in the last few steps. You support auto-updating connections to Google Sheets through Portfolios, and you support Custom Fields in portfolios. Why don’t you support those custom fields connecting automatically to paired data from the projects/tasks within the portfolio? In my use case, I want to track total effort required across our tasks (story points, hours remaining, whatever). Your intended workflow is to require me to aggregate the totals from the tasks by hand for my portfolio each day? Why even have the google sheet auto connect if you don’t support automated updates within the portfolio? (edit: I see - the number of tasks does auto update… I’m going to restate how utterly useless the number of tasks is as a metric for project health, because no two tasks are the same size. This is a completely useless feature to me). If you would automate this, you’d at least give me a way around your lack of support for burndowns, etc within the tool itself (see here [Burndown Charts in Asana](https://forum.asana.com/t/burndown-charts-in-asana/89791)) ---
**Author:** ![Bastien\_Siebman](https://sea2.discourse-cdn.com/asana/user_avatar/forum.asana.com/bastien_siebman/32/172354_2.png) [@Bastien\_Siebman](https://forum.asana.com/u/Bastien_Siebman)\ **Post date:** [3 October 2021 15:53 UTC](https://forum.asana.com/t/showing-sum-of-projects-numeric-field-costs-etc-in-portfolios/102939/10 "2021-10-03T15:53:37Z")
I have had several requests for this from clients and decided to build a custom-made automation. I agree it would be great to have this built-in! ---
**Author:** ![Jenn\_T](https://luna1.co/8d76cd.png) [@Jenn\_T](https://forum.asana.com/u/Jenn_T)\ **Post date:** [9 January 2023 23:02 UTC](https://forum.asana.com/t/showing-sum-of-projects-numeric-field-costs-etc-in-portfolios/102939/11 "2023-01-09T23:02:38Z")
has a function to add sum been added? I need this in my portfolio view but I have 100+ projects and cannot add manually ---
**Author:** ![Bastien\_Siebman](https://sea2.discourse-cdn.com/asana/user_avatar/forum.asana.com/bastien_siebman/32/172354_2.png) [@Bastien\_Siebman](https://forum.asana.com/u/Bastien_Siebman)\ **Post date:** [10 January 2023 07:39 UTC](https://forum.asana.com/t/showing-sum-of-projects-numeric-field-costs-etc-in-portfolios/102939/12 "2023-01-10T07:39:26Z")
> [@Jenn\_T](#): > > has a function to add sum been added Not yet. ---
**Author:** ![anon95228530](https://luna1.co/8d76cd.png) [@anon95228530](https://forum.asana.com/u/anon95228530)\ **Post date:** [25 January 2023 00:45 UTC](https://forum.asana.com/t/showing-sum-of-projects-numeric-field-costs-etc-in-portfolios/102939/13 "2023-01-25T00:45:34Z")
We need this feature - is this possible to get ---
**Author:** ![Craig\_G\_Howe](https://sea2.discourse-cdn.com/asana/user_avatar/forum.asana.com/craig_g_howe/32/149697_2.png) [@Craig\_G\_Howe](https://forum.asana.com/u/Craig_G_Howe)\ **Post date:** [10 February 2023 13:31 UTC](https://forum.asana.com/t/showing-sum-of-projects-numeric-field-costs-etc-in-portfolios/102939/14 "2023-02-10T13:31:02Z")
Only certain fields pull from the underlying projects to populate the overview: Task progress Date Status Owner Is it possible for additional fields too, or just the above? ---
**Author:** ![Andrea\_Mayer](https://sea2.discourse-cdn.com/asana/user_avatar/forum.asana.com/andrea_mayer/32/39226_2.png) [@Andrea\_Mayer](https://forum.asana.com/u/Andrea_Mayer)\ **Post date:** [10 February 2023 14:03 UTC](https://forum.asana.com/t/showing-sum-of-projects-numeric-field-costs-etc-in-portfolios/102939/15 "2023-02-10T14:03:28Z")
Welcome to the Asana Community Forum @Craig_G_Howe! While you can add more custom fields to the portfolio you cannot really pull in data and aggregate info. ![Screenshot_4404](https://us1.discourse-cdn.com/asana/original/3X/5/d/5d746286f10aa81a14e494bbbeb7f8c85429d113.png) I have merged your post into an existing feedback request thread. [You can contact Bastien who created a custom-made automation.](https://forum.asana.com/t/portfolio-custom-fields-should-be-able-to-aggregate-the-totals-from-projects-tasks-within-the-portfolio/137978/2) ---
**Author:** ![Craig\_G\_Howe](https://sea2.discourse-cdn.com/asana/user_avatar/forum.asana.com/craig_g_howe/32/149697_2.png) [@Craig\_G\_Howe](https://forum.asana.com/u/Craig_G_Howe)\ **Post date:** [10 February 2023 14:27 UTC](https://forum.asana.com/t/showing-sum-of-projects-numeric-field-costs-etc-in-portfolios/102939/16 "2023-02-10T14:27:02Z")
Thanks for your help @Andrea_Mayer @Bastien_Siebman How do I get your custom made automation? ---
**Author:** ![Bastien\_Siebman](https://sea2.discourse-cdn.com/asana/user_avatar/forum.asana.com/bastien_siebman/32/172354_2.png) [@Bastien\_Siebman](https://forum.asana.com/u/Bastien_Siebman)\ **Post date:** [10 February 2023 17:50 UTC](https://forum.asana.com/t/showing-sum-of-projects-numeric-field-costs-etc-in-portfolios/102939/17 "2023-02-10T17:50:52Z")
You can send me an email at [bastien@ido-clarity.com](mailto:bastien@ido-clarity.com) with details about what you need 🙂 ---
**Author:** ![Larry\_Berger\_lpb](https://sea2.discourse-cdn.com/asana/user_avatar/forum.asana.com/larry_berger_lpb/32/276017_2.png) [@Larry\_Berger\_lpb](https://forum.asana.com/u/Larry_Berger_lpb)\ **Post date:** [10 February 2023 18:12 UTC](https://forum.asana.com/t/showing-sum-of-projects-numeric-field-costs-etc-in-portfolios/102939/18 "2023-02-10T18:12:15Z")
@Craig_G_Howe, You can change the Task progress column to Milestones and see those rolled up too, another thing pulled from the projects level. Larry ---
**Author:** ![anon11783360](https://luna1.co/8d76cd.png) [@anon11783360](https://forum.asana.com/u/anon11783360)\ **Post date:** [3 April 2023 14:21 UTC](https://forum.asana.com/t/showing-sum-of-projects-numeric-field-costs-etc-in-portfolios/102939/19 "2023-04-03T14:21:25Z")
Hi Asana Decision-makers, Please add functionality to aggregate/track/manage to story points. Huge project/program management gap without that. Thx! ---
**Author:** ![Pramod\_Kumar](https://luna1.co/8d76cd.png) [@Pramod\_Kumar](https://forum.asana.com/u/Pramod_Kumar)\ **Post date:** [5 April 2023 01:14 UTC](https://forum.asana.com/t/showing-sum-of-projects-numeric-field-costs-etc-in-portfolios/102939/20 "2023-04-05T01:14:43Z")
> [@Vanessa\_Künstler](#): > > I have found a work around: I get the total number of the custom field from the project’s dashboard, type that number in manually in my status report. Now the custom field in the portfolio gets automtically populated. It is not ideal to type something in manually but I think it is okay since you should update your projects on a regular basis anyway 😉 Any updates on this? Its a critical field for our projects and manual workaround is also not working for some reason. [Next page](https://forum.asana.com/t/showing-sum-of-projects-numeric-field-costs-etc-in-portfolios/102939.md?page=2)