[GH-ISSUE #7395] [Bug] Grid calculate doesn't update correctly when filter changes #3293

Closed
opened 2026-03-23 21:29:02 +00:00 by mirror · 3 comments
Owner

Originally created by @philiprenich on GitHub (Feb 17, 2025).
Original GitHub issue: https://github.com/AppFlowy-IO/AppFlowy/issues/7395

Bug Description

Given a grid with a Select column and a Number column, using the Sum calculation on the Number column. If I create a view that is filtered by option, the Sum will initially be the correct Sum based on my filter ("Tag A"). However, when I change the filter to "Tag B", the Sum now shows the value of ALL rows, not just the filtered ones. I must remove the calculation and re-add it for it to be correct

How to Reproduce

  1. Create a grid with Select column (add two options) and Number column. Create four rows and fill out the values, using both Select options.
  2. Add a Sum calculation to the Number row
  3. Add a filter to the grid, using the Select column
  4. Use the first Option as the filter.
  5. The Sum will not have updated
  6. Remove the calculation and re-add it. It should show the correct filtered value
  7. Change the filter from Option A to Option B
  8. The sum will not have correctly updated again

Expected Behavior

The calculation should respect the filter and only be applied to the displayed or filtered rows.

Operating System

MacOS

AppFlowy Version(s)

8.6.3

Screenshots

Image Image

Additional Context

No response

Originally created by @philiprenich on GitHub (Feb 17, 2025). Original GitHub issue: https://github.com/AppFlowy-IO/AppFlowy/issues/7395 ### Bug Description Given a grid with a Select column and a Number column, using the Sum calculation on the Number column. If I create a view that is filtered by option, the Sum will initially be the correct Sum based on my filter ("Tag A"). However, when I change the filter to "Tag B", the Sum now shows the value of ALL rows, not just the filtered ones. I must remove the calculation and re-add it for it to be correct ### How to Reproduce 1. Create a grid with Select column (add two options) and Number column. Create four rows and fill out the values, using both Select options. 2. Add a Sum calculation to the Number row 3. Add a filter to the grid, using the Select column 4. Use the first Option as the filter. 5. The Sum will not have updated 6. Remove the calculation and re-add it. It should show the correct filtered value 7. Change the filter from Option A to Option B 8. The sum will not have correctly updated again ### Expected Behavior The calculation should respect the filter and only be applied to the displayed or filtered rows. ### Operating System MacOS ### AppFlowy Version(s) 8.6.3 ### Screenshots <img width="461" alt="Image" src="https://github.com/user-attachments/assets/f1f0d4aa-60a4-4786-b274-83daee88fac7" /> <img width="427" alt="Image" src="https://github.com/user-attachments/assets/b983424a-a8bb-4dea-bf8e-5cab4d9266b8" /> ### Additional Context _No response_
mirror 2026-03-23 21:29:02 +00:00
Author
Owner

@annieappflowy commented on GitHub (Jun 15, 2025):

The web app doesn't have this bug

<!-- gh-comment-id:2973518465 --> @annieappflowy commented on GitHub (Jun 15, 2025): The web app doesn't have this bug
Author
Owner

@philiprenich commented on GitHub (Jun 15, 2025):

Thought I'd repro this again since a lot of work has happened since I posted. It's still there. I did notice it's only incorrect when setting the filters. If I set a filter and the sum is incorrect, but then navigate to a different page (or view in the grid) and come back, it's correct. So it seems to be a simple reactivity issue for that particular interaction.

<!-- gh-comment-id:2973604491 --> @philiprenich commented on GitHub (Jun 15, 2025): Thought I'd repro this again since a lot of work has happened since I posted. It's still there. I did notice it's only incorrect when setting the filters. If I set a filter and the sum is incorrect, but then navigate to a different page (or view in the grid) and come back, it's correct. So it seems to be a simple reactivity issue for that particular interaction.
Author
Owner

@appflowy commented on GitHub (Dec 9, 2025):

This issue has already been fixed and will be included in the upcoming release (0.10.7). I’m closing this issue.

<!-- gh-comment-id:3629996074 --> @appflowy commented on GitHub (Dec 9, 2025): This issue has already been fixed and will be included in the upcoming release (0.10.7). I’m closing this issue.
Sign in to join this conversation.
No milestone
No project
No assignees
1 participant
Notifications
Due date
The due date is invalid or out of range. Please use the format "yyyy-mm-dd".

No due date set.

Dependencies

No dependencies set.

Reference
AppFlowy-IO/AppFlowy#3293
No description provided.