https://community.qlik.com/t5/QlikView/How-to-calculate-Weighted-Average/m-p/1691412#M726787 <P>Say for example, for the Loan number 123, its weighted average should be calculated like:</P><P>3,559,850/(3,559,850+12,750,000+22,875,000+15,050,000) * 2.5%</P><P>For AAA company, their weighted average is the sum of all the loan's weighted average.</P><P>&nbsp;</P> Tue, 07 Apr 2020 03:50:05 GMT Rcp_17 2020-04-07T03:50:05Z https://community.qlik.com/t5/QlikView/How-to-calculate-Weighted-Average/m-p/1691109#M726785 <P>I tried to use formulas from other discussions, but it seems they are not working for my date set below.</P><TABLE width="558"><TBODY><TR><TD width="64"><STRONG>Loan code</STRONG></TD><TD width="64"><STRONG><U>Interest Margin</U></STRONG></TD><TD width="84"><STRONG><U>Balance </U></STRONG></TD><TD width="346"><STRONG>Name</STRONG></TD></TR><TR><TD>123</TD><TD>2.5</TD><TD>(3,559,850)</TD><TD>AAA</TD></TR><TR><TD>1234</TD><TD>2.25</TD><TD>(12,750,000)</TD><TD>AAA</TD></TR><TR><TD>12345</TD><TD>2</TD><TD>(22,875,000)</TD><TD>AAA</TD></TR><TR><TD>123456</TD><TD>2</TD><TD>(15,050,000)</TD><TD>AAA</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Thanks for your help!</P> Sat, 16 Nov 2024 18:49:56 GMT https://community.qlik.com/t5/QlikView/How-to-calculate-Weighted-Average/m-p/1691109#M726785 Rcp_17 2024-11-16T18:49:56Z https://community.qlik.com/t5/QlikView/How-to-calculate-Weighted-Average/m-p/1691152#M726786 <P>hi&nbsp;</P><P>it's not clear what exactly you look for&nbsp;</P><P>weighted average of what ?</P> Mon, 06 Apr 2020 09:07:41 GMT https://community.qlik.com/t5/QlikView/How-to-calculate-Weighted-Average/m-p/1691152#M726786 lironbaram 2020-04-06T09:07:41Z https://community.qlik.com/t5/QlikView/How-to-calculate-Weighted-Average/m-p/1691412#M726787 <P>Say for example, for the Loan number 123, its weighted average should be calculated like:</P><P>3,559,850/(3,559,850+12,750,000+22,875,000+15,050,000) * 2.5%</P><P>For AAA company, their weighted average is the sum of all the loan's weighted average.</P><P>&nbsp;</P> Tue, 07 Apr 2020 03:50:05 GMT https://community.qlik.com/t5/QlikView/How-to-calculate-Weighted-Average/m-p/1691412#M726787 Rcp_17 2020-04-07T03:50:05Z https://community.qlik.com/t5/QlikView/How-to-calculate-Weighted-Average/m-p/1697741#M726788 <P>Check the following Design Blog post, hopefully that may be of some help:</P><P><A href="https://community.qlik.com/t5/Qlik-Design-Blog/Average-Which-average/ba-p/1466654" target="_blank">https://community.qlik.com/t5/Qlik-Design-Blog/Average-Which-average/ba-p/1466654</A></P><P>Regards,<BR />Brett</P> Wed, 29 Apr 2020 13:43:38 GMT https://community.qlik.com/t5/QlikView/How-to-calculate-Weighted-Average/m-p/1697741#M726788 Brett_Bleess 2020-04-29T13:43:38Z