- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 19, 2025 01:15 AM - edited ‎Feb 19, 2025 01:30 AM
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
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 19, 2025 01:43 AM - edited ‎Feb 19, 2025 01:44 AM
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:
Or you can display this value, a little bit simpler, in the Groups table if that works for you:
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
