Weight Avg FICO by Product

lbunnell — Sat, 16 Nov 2024 19:35:59 GMT

I'm trying to create a straight table chart that shows the weight average FICO for each Product by Outstanding Balance. This calculation

sum(TOTAL <PRODUCT> [FICO] * aggr(sum(OUTSTANDING_BALANCE),[FICO],PRODUCT))/sum(TOTAL aggr(sum(OUTSTANDING_BALANCE),[FICO]))

seems to give an overall total correctly, however, the FICO's I'm getting are 3, 432, and 299 which add up to 734. I'm looking to have the WA FICO on each row (e.g. (I'm making these up...) Product A, WA FICO 732; Product B, WA FICO, 735; Product C, WA FICO 734)

Product	Outstanding Balance	WA FICO (what I'm getting)	WA FICO (what I want)
A	$7,000	3	732
B	$1,000,000	432	735
C	$670,000	299	734
Total	$1,677,000	734	734

Re: Weight Avg FICO by Product

lbunnell — Fri, 22 Nov 2019 20:18:22 GMT

This seems to do the trick. Let me know if I'm wrong.

=sum(TOTAL <PRODUCT> [FICO]*aggr(sum( [OUTSTANDING_BALANCE]),[FICO]))/sum(total <PRODUCT> aggr(sum( [OUTSTANDING_BALANCE]),[FICO]))

topic Re: Weight Avg FICO by Product in QlikView

Weight Avg FICO by Product

Re: Weight Avg FICO by Product