How to calculate Weighted Average

[Rcp_17]

I tried to use formulas from other discussions, but it seems they are not working for my date set below.

Loan code	Interest Margin	Balance	Name
123	2.5	(3,559,850)	AAA
1234	2.25	(12,750,000)	AAA
12345	2	(22,875,000)	AAA
123456	2	(15,050,000)	AAA

Thanks for your help!

[lironbaram]

hi 

it's not clear what exactly you look for 

weighted average of what ?

[Rcp_17]

Say for example, for the Loan number 123, its weighted average should be calculated like:

3,559,850/(3,559,850+12,750,000+22,875,000+15,050,000) * 2.5%

For AAA company, their weighted average is the sum of all the loan's weighted average.

[Brett_Bleess]

Check the following Design Blog post, hopefully that may be of some help:

https://community.qlik.com/t5/Qlik-Design-Blog/Average-Which-average/ba-p/1466654

Regards,
Brett