Creating New Table with SUMPRODUCT from Existing Tables

[dashmarley11]

I have 2 separate tables (PmtTable, RateTable) that I'd like to use to create a new table (NewTable) that has a SUMPRODUCT calculation that is derived using the two original tables.  Using Excel it would look something like this:   
=SUMPRODUCT('RateTable'[A:A], 'RateTable'[E:E], 'PmtTable'[E:E] / SUMPRODUCT('RateTable'[A:A], 'PmtTable'[E:E])

RateTable

  A            B               C                D                 E

Term	Rate_012	Rate_024	Rate_036	Rate_048
1	.05438	.051989	.050373	.04967
2	.05318	.052763	.055737	.04896

PmtTable

 A              B               C               D                 E

Term	Rate_012	Rate_024	Rate_036	Rate_048
1	81441	39704	25804	18862
2	81780	39870	25911	19273

[Anonymous]

Hi @dashmarley11 

There seems to be something wrong with the code you provided, and I don't quite understand what you need.

If you can, please provide some dummy data and desired results. It is best presented in table form.

Regards,

Nono Chen