Sum of values in a foreach loop php

Question

I have a response like this:

  "data": [
            {

                "pay": "2010000",

            },
            {

                "pay": "3010000",

            },
            {

                "pay": "3920000",

            },
]

    foreach ($data as $data) {
              $sum += $data['pay'];

              array_push($newArr, array(
                        "finalResult" => '0',
                     )
                    );
            }

I want to get (individual pay divided by sum of all pay) results and should push this value into array. I have a foreach loop where I'm trying to get the final result. But the final result array is showing incorrect data. Is there anything I'm missing?

I tried this with two foreach loops like this. But I'm getting wrong result

foreach ($newArr as $newArr_key => $newArr_value) {

            if ($sum != 0) {
                $finalResult = $data['pay']/ $sum;


                if (isset($finalResult) && $finalResult != '') {
                    $newArr[$newArr_key]['finalResult'] = $finalResult;
                }

            } else {
                $finalResult = 'Division by Zero';
            }


            }

The input data you show is neither a correct json nor an array also. Please correct your input data first and then ask question — Death-is-the-real-truth
– Death-is-the-real-truth, Commented Apr 20, 2018 at 21:05
Can you please correct the syntax errors in your question to create a minimal reproducible example? I think I see the real problem, but it's difficult to address it with so many other problems in the way. — Don't Panic
– Don't Panic, Commented Apr 20, 2018 at 21:05

Syscall · Accepted Answer · 2018-04-20 21:41:37Z

2

You could use array_sum() with array_column() to compute the total sum of "pay". Then you could use array_map() to compute the average of individual sum along the total sum.

$data = [
    ["pay" => "2010000"],
    ["pay" => "3010000"],
    ["pay" => "3920000"],
];
$sum = array_sum(array_column($data, 'pay'));
$out = array_map(function($item) use($sum) {
    return ['finalResult' => $item['pay'] / $sum] ;
}, $data);
print_r($out);

Outputs:

Array
(
    [0] => Array
        (
            [finalResult] => 0.2248322147651
        )

    [1] => Array
        (
            [finalResult] => 0.33668903803132
        )

    [2] => Array
        (
            [finalResult] => 0.43847874720358
        )

)

Or :

$data = [
    ["pay" => "2010000"],
    ["pay" => "3010000"],
    ["pay" => "3920000"],
];
$sum = array_sum(array_column($data, 'pay'));
$out = array_map(function($item) use($sum) {
    return $item['pay'] / $sum ;
}, $data);
print_r($out);

Output:

Array
(
    [0] => 0.2248322147651
    [1] => 0.33668903803132
    [2] => 0.43847874720358
)

answered Apr 20, 2018 at 21:41

Syscall

19.8k10 gold badges44 silver badges60 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Syscall Over a year ago

Thank you @Jeff. Yer, don't forget to post an example of the desired output for your future questions to help answerers to understand what you really want. Thank you :)

Collectives™ on Stack Overflow

Sum of values in a foreach loop php

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related