Skip to main content

How do I use sum values automatically calculated when grouping fields for other formulas?

I have to calculate the sum of values of a grouped field in other formulas. Is it possible? someone told about rollup, but I did not manage to obtain any useful result. 

I would need to obtain something like that in the screenshot in the sum field...

Thanks in advance for your help 🙂

Hi! It would be hard to answer this without accurate table names and an idea of what you are trying to do. Without any context, however, it does seem like rollup fields located in a separate table is a good recommendation  - Brian


Yeap, it's possible and you'd use rollup fields for it like you said.  What issues did you face while trying to do that?

https://support.airtable.com/docs/rollup-field-overview


Yeap, it's possible and you'd use rollup fields for it like you said.  What issues did you face while trying to do that?

https://support.airtable.com/docs/rollup-field-overview


followed all the material but rollup is everytime not working. perhaps I'm wrong with something. I need to use the sum calculated when i group my records by Id. Could you please make an example made upon my example?

What am I missing? Lookup field must to be in another tab? there are only three or four passages what I'm doing wrong? Is there somewhere an example table online?

Thanks in advance 🙂


followed all the material but rollup is everytime not working. perhaps I'm wrong with something. I need to use the sum calculated when i group my records by Id. Could you please make an example made upon my example?

What am I missing? Lookup field must to be in another tab? there are only three or four passages what I'm doing wrong? Is there somewhere an example table online?

Thanks in advance 🙂


Sure, here

 


Thank you very much, but I can't figure how table 1 link to grouped items automatically populates himself with grouped values...


Thank you very much, but I can't figure how table 1 link to grouped items automatically populates himself with grouped values...


Ah, you're going to need to use an automation for that


thanks Adam, is there a preset automation for such a task?


Reply