Calculation between 2 tables

[guenfood]

Hello,

I have 2 tables, with a relation on the Attribute column.

The 1st "Capacity" table is composed as follows:

Program	Attribute	Value
Purchase	Joelle	20
Purchase	Nicolas	10
Sale	Joelle	15
Sale	Nicolas	5

My second "Resources" table:

Dated	Attribute	Program
09/07/2021	Joelle	Sale
09/07/2021	Nicolas	Sale
04/10/2021	Joelle	Purchase
04/10/2021	Nicolas	Purchase
05/10/2021	Joelle	Sale
05/10/2021	Nicolas	Purchase
05/10/2021	Nicolas	Sale

On my "Capacity" table, it is the volume that an attribute can process per day depending on the Program.
On my "Resources" table, it is the assignment per day of an attribute on a program.

I must therefore highlight the overall volume that will be processed according to the programs and assignments of the attributes.
example:
For 09/07, for the "Sale" program, I must obtain a value equivalent to 15 (Joëlle's Selling Capacity) + 5 (Nicolas Selling Capacity) = 20

How can I proceed?
Thank you in advance for your help.

[Anonymous]

Hi @guenfood 

Please try the following:

Hope this helps. Give a thumbs up if it works!

-JID

[guenfood · Accepted solution]

Hi JDIBC,

Thanks a lot. It works great !