Sum up the fields of a colomn from a different table

[MarineSorato]

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

[TheTimeSavingCo]

Does this look right?

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

Link to base

[Pascal_Gallais-]

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-]

Sorry,

I started writting my answer before Adam posted his answer.

Do not consider my answer.

Regards,

Pascal

[TheTimeSavingCo]

@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!