Create a Calculated Column from Different Tables

Hi,

I'm trying to create a calculated column "Total Stock" and add the Total xx columns from two different tables.

But the total stock calculated seems to be a cumulative total instead of the total for the Total xx columns of that row.

How can I make the formula correct?