# June 27, 2024 / đź’ś Workspace Q&A, Totals row in Table View for numeric fields (experimental) **URL:** \ **Category:** Changelog\ **Created:** [June 27, 2024, 12:51pm UTC](https://community.fibery.io/t/june-27-2024-workspace-q-a-totals-row-in-table-view-for-numeric-fields-experimental/6326 "2024-06-27T12:51:11Z")\ **Posts on this page:** 10\ **Page:** 2
**Author:** ![Minh\_Tri\_Do\_Hang](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/minh_tri_do_hang/32/6791_2.png) [@Minh\_Tri\_Do\_Hang](https://community.fibery.io/u/Minh_Tri_Do_Hang)\ **Post date:** [July 1, 2024, 8:27am UTC](https://community.fibery.io/t/june-27-2024-workspace-q-a-totals-row-in-table-view-for-numeric-fields-experimental/6326/21 "2024-07-01T08:27:27Z")
I’m trying to using this model to consumed events from bookmarked article in Periodic database daily, What condition should I set in “On schedule” to trigger this for each day only so that will not be duplicated automation for those triggered ![image](https://us1.discourse-cdn.com/flex020/uploads/fibery/original/2X/4/4183e96ac22314b48c29c0b93e92eff7999faab0.png) ---
**Author:** ![interr0bangr](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/interr0bangr/32/8089_2.png) [@interr0bangr](https://community.fibery.io/u/interr0bangr)\ **Post date:** [August 9, 2024, 11:10pm UTC](https://community.fibery.io/t/june-27-2024-workspace-q-a-totals-row-in-table-view-for-numeric-fields-experimental/6326/22 "2024-08-09T23:10:41Z")
I’ve got a lot of fields that are named the same across multiple databases so they can be merged under a single column in a table view to save screen real estate. However, when that column gets summed up in the total row, it counts everything in the column, when I often only want to count the values from one database. Could you add the ability to filter databases out of being included in the total row counts? ---
**Author:** ![daoud](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/daoud/32/11021_2.png) [@daoud](https://community.fibery.io/u/daoud)\ **Post date:** [July 3, 2025, 1:52pm UTC](https://community.fibery.io/t/june-27-2024-workspace-q-a-totals-row-in-table-view-for-numeric-fields-experimental/6326/23 "2025-07-03T13:52:40Z")
> [@mdubakov](#): > > Totals row in Table View for numeric fields (experimental) Any plans to extend Totals Row in Table View to support SUM, AVG, etc. for Single Select / Multi Select Fields where a numeric value is specified? ---
**Author:** ![Chr1sG](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/chr1sg/32/3941_2.png) [@Chr1sG](https://community.fibery.io/u/Chr1sG)\ **Post date:** [July 3, 2025, 3:04pm UTC](https://community.fibery.io/t/june-27-2024-workspace-q-a-totals-row-in-table-view-for-numeric-fields-experimental/6326/24 "2025-07-03T15:04:10Z")
If I understand correctly, you could make a formula to get the select field value, and then this field can be aggregated (SUM, AVG, etc. ) in table view. ---
**Author:** ![B\_Sp](https://avatars.discourse-cdn.com/v4/letter/b/e8c25b/32.png) [@B\_Sp](https://community.fibery.io/u/B_Sp)\ **Post date:** [July 4, 2025, 4:24am UTC](https://community.fibery.io/t/june-27-2024-workspace-q-a-totals-row-in-table-view-for-numeric-fields-experimental/6326/25 "2025-07-04T04:24:03Z")
I agree would like to do this natively, have tried to do a formula per @ChrisG but it’s too technical without a developer! My use case: I have a one-to-many relation where I have a # field in the many related entities. I’d love to be able to get built-in a sum of that # in the relation via lookup. Then display that in a table. In fact I have a big project right now where I could really use this adding up at a glance in said table! Thanks. ---
**Author:** ![daoud](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/daoud/32/11021_2.png) [@daoud](https://community.fibery.io/u/daoud)\ **Post date:** [July 4, 2025, 2:44pm UTC](https://community.fibery.io/t/june-27-2024-workspace-q-a-totals-row-in-table-view-for-numeric-fields-experimental/6326/26 "2025-07-04T14:44:50Z")
Agreed; I have seen this done. My question is really roadmap: seems a fairly straight forward feature to include. ---
**Author:** ![Chr1sG](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/chr1sg/32/3941_2.png) [@Chr1sG](https://community.fibery.io/u/Chr1sG)\ **Post date:** [July 4, 2025, 2:53pm UTC](https://community.fibery.io/t/june-27-2024-workspace-q-a-totals-row-in-table-view-for-numeric-fields-experimental/6326/27 "2025-07-04T14:53:46Z")
> [@daoud](#): > > seems a fairly straight forward feature to include. I think SUM is relatively simple. However, I’m not sure what the expected behaviour would be for AVG. For example, if I have a multi-select field, with options A, B, C, D, E with values 1, 2, 3, 4, 5 what would you expect a table view to show in the following situation: | Name | Multi-select | AVG | | --- | --- | --- | | Thing | A, C | 2 | | Another thing | B, C, D | 3 | | Third thing | - | - | | More stuff | A, E | 3 | | | | AVG: ? | ---
**Author:** ![B\_Sp](https://avatars.discourse-cdn.com/v4/letter/b/e8c25b/32.png) [@B\_Sp](https://community.fibery.io/u/B_Sp)\ **Post date:** [July 4, 2025, 3:19pm UTC](https://community.fibery.io/t/june-27-2024-workspace-q-a-totals-row-in-table-view-for-numeric-fields-experimental/6326/28 "2025-07-04T15:19:34Z")
Agreed would love to see this feature. And to @Chr1sG’s point, I’d be happy with just SUM right now… ---
**Author:** ![daoud](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/daoud/32/11021_2.png) [@daoud](https://community.fibery.io/u/daoud)\ **Post date:** [July 4, 2025, 4:52pm UTC](https://community.fibery.io/t/june-27-2024-workspace-q-a-totals-row-in-table-view-for-numeric-fields-experimental/6326/29 "2025-07-04T16:52:47Z")
I see what you are saying. AVG of AVG column and MED of MED column are a bit more difficult (and AVG of MED column and MED of AVG column probably shouldn’t be supported… messy). I would expect all the values would need to be considered (not AVG of AVG or MED of MED): - Row AVE would include all selections for each Row; as shown in your example - Total AVE would include all 7 selections across all 4 Rows; e.g., ((1+3)+(2+3+4)+(1+5))/7 = 2.7 - Row MED would include all selections for each Row - Total MED would include all 7 selections across all 4 Rows; {1, 3, 2, 3, 4, 1, 5} → {1, 1, 2, **3** , 3, 4, 5} = 3 | Name | Multi-select | AVG | MED | | --- | --- | --- | --- | | Thing | A, C | 2.0 | 2 | | Another thing | B, C, D | 3.0 | 3 | | Third thing | - | - | | | More stuff | A, E | 3.0 | 3 | | | | **2.7** | **3** | AFAIK, this approach is statistically valid and hopefully how most users would expect the calcs to work. ---
**Author:** ![helloitse](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/helloitse/32/498_2.png) [@helloitse](https://community.fibery.io/u/helloitse)\ **Post date:** [January 12, 2026, 5:42pm UTC](https://community.fibery.io/t/june-27-2024-workspace-q-a-totals-row-in-table-view-for-numeric-fields-experimental/6326/30 "2026-01-12T17:42:04Z")
> [@mdubakov](#): > > Now at the bottom of every **numeric** column in Table View, you can run calculations that will show you some aggregated information: Sum, Avg, Min, Max, Count. It would be nice to see a total for enum columns where the value field is enabled. [Previous page](https://community.fibery.io/t/june-27-2024-workspace-q-a-totals-row-in-table-view-for-numeric-fields-experimental/6326.md?page=1)