How do I sum subarray elements and group by subarray value?

Question

I want to sum subarray values and group by a subarray value but I am getting error: 'Undefined index: EEReg'.

The array is as follows.

and the current code is;

$total_balances = array();
foreach ($balances as $balance) {
    foreach ($balance as $key => $value) {
        if ($key == 'MemberNumber' || $key == 'Portfolio') {
            continue;
        } else {
            $total_balances[$balance['Portfolio']][$key] += $value;
        }
    }
}

I expect the result to be;

$total_balances = [
 "Aggressive" => [
    "EEReg" => "Sum of EEReg where Portfolio is Aggressive",
    "ERReg" => "Sum of ERReg where Portfolio is Aggressive",
],
 "Moderate" => [
    "EEReg" => "Sum of EEReg where Portfolio is Moderate",
    "ERReg" => "Sum of ERReg where Portfolio is Moderate",
]
]

You need to make sure that `$total_balances[$balance['Portfolio']]` actually exists before you do `$total_balances[$balance['Portfolio']][$key]`. If it doesn't exist yet, create it and _then_ use it. If it does exist, just use it. — Patrick Q, Jul 16 '19 at 11:52

score 1 · Accepted Answer · answered Jul 16 '19 at 11:56

You need to use foreach only once and also you need to define the keys in $total_balance array before using them. Please see below code

$total_balances = array();
foreach ($balances as $balance) {
    if( !isset( $total_balances[$balance['Portfolio']] )) {
        $total_balances[$balance['Portfolio']] = array('EEREG' => 0, 'ERREG' => 0); 
    }
    $total_balances[$balance['Portfolio']]['EEREG'] += $balance['EEREG'];
    $total_balances[$balance['Portfolio']]['ERREG'] += $balance['ERREG'];
}

How do I sum subarray elements and group by subarray value?

1 Answers1