Solved: Calculate between 2 different tables. - Page 2

Msidacappu · 08-24-2022 02:00 AM

Hi there,

I have 2 tables, tableA is the money I received from project123, tableB is the money I paid to the suppliers of project123. I would like to know the profit of each project, how to set the formula?

I may receive/pay the money of project123 for more than 1 time, so I will have to SUM the values of project123 in tableA/tableB first, and do the calculation.

TeeSee1

I believe it more sensible to have a separate project table to place this expression in.

But I see no reason that you cannot technically put this in Table A (or B). You will have multiple data of the same value though.

View solution in original post