Aggregation issue

[renjithpl]

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

[tresesco · Accepted solution]

Try:

=Sum( [Exposure (AUD)] * Risk Weight )