# UX: Calculations - totals - is this correct? **URL:** \ **Category:** Bugs & Issues\ **Created:** [October 26, 2025, 4:25pm UTC](https://community.fibery.io/t/ux-calculations-totals-is-this-correct/9887 "2025-10-26T16:25:18Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![myg\_ge](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/myg_ge/32/12457_2.png) [@myg\_ge](https://community.fibery.io/u/myg_ge)\ **Post date:** [October 26, 2025, 4:25pm UTC](https://community.fibery.io/t/ux-calculations-totals-is-this-correct/9887/1 "2025-10-26T16:25:18Z")
![image](https://us1.discourse-cdn.com/flex020/uploads/fibery/original/2X/a/a9ebce6c6eb8da39121207a81d895daa7c7816b0.png) I’m confused by the calculations shown on the bottom of this grid. Is this the way it should be working? ---
**Author:** ![Tommy\_Hedley](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/tommy_hedley/32/6468_2.png) [@Tommy\_Hedley](https://community.fibery.io/u/Tommy_Hedley)\ **Post date:** [October 26, 2025, 5:48pm UTC](https://community.fibery.io/t/ux-calculations-totals-is-this-correct/9887/2 "2025-10-26T17:48:22Z")
I think the sums are based on the values of all entities in the view by filter, not by what is collapsed in the UI. I would guess that there are probably some other entities nested in your top level DB that total up to the sums that are shown. ---
**Author:** ![myg\_ge](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/myg_ge/32/12457_2.png) [@myg\_ge](https://community.fibery.io/u/myg_ge)\ **Post date:** [October 26, 2025, 6:13pm UTC](https://community.fibery.io/t/ux-calculations-totals-is-this-correct/9887/3 "2025-10-26T18:13:51Z")
Hey Tommy, Thanks. I understand that. My question is whether that’s how this is supposed to work? Cause it looks misleading. ---
**Author:** ![Tommy\_Hedley](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/tommy_hedley/32/6468_2.png) [@Tommy\_Hedley](https://community.fibery.io/u/Tommy_Hedley)\ **Post date:** [October 26, 2025, 6:19pm UTC](https://community.fibery.io/t/ux-calculations-totals-is-this-correct/9887/4 "2025-10-26T18:19:38Z")
Ah, fair point. I suppose it could be nice if it re-calculated based on what is visible. ---
**Author:** ![timothy](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/timothy/32/11812_2.png) [@timothy](https://community.fibery.io/u/timothy)\ **Post date:** [October 27, 2025, 3:13pm UTC](https://community.fibery.io/t/ux-calculations-totals-is-this-correct/9887/6 "2025-10-27T15:13:21Z")
I’ve been told yes it is – the sum is supposed to be the entire view. If I need totals of specific groups I have to switch to Reports. ---
**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:** [October 27, 2025, 3:34pm UTC](https://community.fibery.io/t/ux-calculations-totals-is-this-correct/9887/7 "2025-10-27T15:34:58Z")
Alternatively, you can add the required formula(s) on the database that is used for grouping, so that they too have a calculation, rather than empty cells ![image](https://us1.discourse-cdn.com/flex020/uploads/fibery/original/2X/b/b8f0c58180829c0b46c7781c73f8ef87d15b584e.png) ---
**Author:** ![timothy](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/timothy/32/11812_2.png) [@timothy](https://community.fibery.io/u/timothy)\ **Post date:** [October 27, 2025, 3:47pm UTC](https://community.fibery.io/t/ux-calculations-totals-is-this-correct/9887/8 "2025-10-27T15:47:11Z")
Good point – that works as long as the filters of the view are not expected to change. I’ve had people confused because they adjust the personal filters and then the formulas are wrong.