Help

The Community will be undergoing maintenance from Friday February 21 - Friday, February 28 and will be "read only" during this time. To learn more, check out our Announcements blog post.

Do we have formula to sum something grouped by group

Topic Labels: Formulas
137 1
cancel
Showing results for 
Search instead for 
Did you mean: 
blueliagain
4 - Data Explorer
4 - Data Explorer

Hello

Sorry about the title. Actually, I don't really know how to ask it correctly.

Basically, I want the circled value to be the sum of the above 'Max' values. In this case, I expect 500 + 100 = 600.

Is there any alternative to achieve that since I cannot switch the function to SUM; otherwise, the MAX would be lost...

I goal is to show that sum "600" somewhere. 

Thanks

Screenshot 2025-02-19 at 3.23.36 PM.png

1 Reply 1
Milan_Automable
6 - Interface Innovator
6 - Interface Innovator

Hi @blueliagain , welcome to the community! 🙂

More of a workaround, but if you're using a record field (or you can switch to that), you can display this as the sum of a separate column like this:

1) Add a rollup in the Groups table with Max / Count
2) Add a lookup field for this rollup in your original table
3) This new field's sum will now display the sum of maxes by category.

This is how to build:
GroupSumMax.gif

Or you can display this value, a little bit simpler, in the Groups table if that works for you:

GroupSumMax2.gif

Not a perfect solution, but I hope it helps 🙂 Here is the base I used for the demonstration.

-- Best, Milan - Automable.AI Free Airtable consultation