Weighted average calculation

[Figueiredo_Luis]

I want to calculate the weighted average in terest rate for deposits considering the following variables: 
 - Deposit amount;
 - Interest Rate; and 
 - activation date

The table below is showing the result i got using sumproduct function in excel.

[amitchandak · Accepted solution]

@Figueiredo_Luis , It need to like

divide(Sumx(Table, [Value1] *[Value2]),sum(Table[Value1]) )

[amitchandak · Accepted solution]

@Figueiredo_Luis , It need to like

divide(Sumx(Table, [Value1] *[Value2]),sum(Table[Value1]) )

[Figueiredo_Luis · Accepted solution]

Thanks for your support.

Regards,

FLuis