Skip to main content

Sum up the fields of a colomn from a different table

  • August 21, 2024
  • 4 replies
  • 48 views

Forum|alt.badge.img+4

Hello community,

I'd like to use a field from a different table in a formula.

How can I do this ?

--

I have a table with a list of attending people to a specific event and how much they paid.
I have a table with a list of the different events and I want to display the total payments received. 

Marine

4 replies

TheTimeSavingCo
Forum|alt.badge.img+31

Does this look right?


If so, it's a Rollup field with the formula `SUM(values)`

Link to base


Pascal_Gallais-
Forum|alt.badge.img+21

Hello Marine,

You can do that by adding a rollup field in your Events table.

First step, if not done yet, is to link "Attendees" table to Events Table:

Field "Events" is a linked field to table Events:

You then add a rollup field in table Events:

To get the following result:

Regards,

Pascal

 


Pascal_Gallais-
Forum|alt.badge.img+21

Sorry,

I started writting my answer before Adam posted his answer.

Do not consider my answer.

Regards,

Pascal


TheTimeSavingCo
Forum|alt.badge.img+31

Sorry,

I started writting my answer before Adam posted his answer.

Do not consider my answer.

Regards,

Pascal


@MarineSoratoAh, please consider Pascal's answer; his is clearer than mine and includes a step by step process of how to create the rollup field

@Pascal_Gallais-Hahaha I've done this a couple of times too, sorry about that!