Help merging two financial tables?

In the screenshot above, I have Project Titles and the "Amount" Column coming from one table. These Projects are linked via an authorization number to financial tables coming out of an ERP... The columns "POs Written", "Paid to Date" are the columns in question.

I'm trying to match the financial information from the ERP to the Amounts from the outside data source ("Amount" Column) to easily highlight discrepancies. The problem is, each line in the table for the ERP columns are populating as the sum of the entire column ($80 million plus).

Here is a picture of my model:

The ERP is "CAPEX Metrics".

Could someone with more experience help explain what my issue is here/point me in the right direction for a solution? One thing to note is the CAPEX Metrics table houses more capital expenditure data than what is in the Purchasing MER/CER table, which the Amounts column is pulling from. I only one to report on these values from the Purchasing MER/CER list.

Thanks!