Forum Discussion

Figueiredo_Luis's avatar
Figueiredo_Luis
Frequent Visitor
3 years ago
Solved

Weighted average calculation

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 show...
Need Help
  • amitchandak's avatar
    amitchandak
    3 years ago

    Figueiredo_Luis , It need to like

     

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

  • Figueiredo_Luis's avatar
    Figueiredo_Luis
    3 years ago

    Thanks for your support.

     

    Regards,

    FLuis

amitchandak's avatar
amitchandak
Super User
3 years ago

Figueiredo_Luis , It need to like

 

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

  • Figueiredo_Luis's avatar
    Figueiredo_Luis
    Frequent Visitor
    3 years ago

    Thanks for your support.

     

    Regards,

    FLuis