Hi All,
I have table like below
| Name on Top 20 | Existing Managed SPVs | Exposure (AUD) | Risk Weight | Risk Weighted Assets |
| FP Turbo Trust AUD | FP Turbo Trust AUD (Senior) | $202,648,646.66 | 0.07 | $14,185,405.27 |
| FP Turbo Trust AUD | FP Turbo Trust AUD (Mezz) | $9,737,662.24 | 0.15 | $1,460,649.34 |
| FP Turbo Trust AUD | FP Turbo Trust AUD (Junior) | $7,105,861.64 | 0.2 | $1,421,172.33 |
| Total | Total | $219,492,170.54 | | $17,067,226.93 |
I want to calculate the Risk Weighted Assets, the formula = Sum([Exposure (AUD)]) * Risk Weight
Now, I will remove "Exixting Managed SPVs" in my orginal Chart, I get Risk Weighted Assets null, like in below chart, which is obvious that we have different risk weights. (0.07, 0.15, 0.2)
| Name on Top 20 | Exposure (AUD) | Risk Weight | Risk Weighted Assets |
| FP Turbo Trust AUD | $219,492,170.54 | - | - |
| Total | $219,492,170.54 | | $0.00 |
I want the table like below:
| Name on Top 20 | Exposure (AUD) | Risk Weight | Risk Weighted Assets |
| FP Turbo Trust AUD | $219,492,170.54 | - | $17,067,226.93 |
Any idea ?
Ren
