Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
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]))
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]))