Format number in array within an array_sum

Question

I have a view in a laravel project where I have to print the sum of some array columns.

I Have this kind of code to achieve the result:

@foreach($data as $row)

.......

  @foreach($row as $key => $value)

   @if(in_array($key, ['PARZ. IN', 'PARZ. OUT', 'LORDO', 'PREU', 'AAMS', 'RETE ESER.',
                     'RETE OPER.', 'NETTO', 'UTILE ESER.', 'UTILE GEST.']))

    <th style="padding: 1em 0; background-color: #D9EDF7" class="text-center">

       {!! number_format(array_sum( array_column($data, $key)),2, ',', '.') !!} €

    </th>

   @else

    <th style="padding: 1em 0; background-color: #D9EDF7" class="text-center"></th>

   @endif

  @endforeach

@endforeach

It works fine. But there is a problem.

The numeric columns have a formatted italian currency number like this:

1.267,76 €

So the sum is printed wrong, because numbers have wrong format to perform the sum.

How can format all the numbers to 1267.76 before performing the sum within blade view?

Thanks

Can you please share the array

Hari Darshan
– Hari Darshan

2021-05-23 13:27:02 +00:00
Commented May 23, 2021 at 13:27 — Hari Darshan
– Hari Darshan, Commented May 23, 2021 at 13:27

DannyV · Accepted Answer · 2021-05-23 13:46:39Z

1

Ok, I'm trying to find the solution from yesterday. Now I found it on myself few minutes after I posted the question.

I modified the code to get the sum in this way:

{!! number_format(array_sum( str_replace([' €', '.', ','], ['', '', '.'],
                                    array_column($data, $key)) ),2, ',', '.') !!} €

Using str_replace with array_column the formatted currency numbers were replaced with standard numbers. Then number_format print the sum with original format.

answered May 23, 2021 at 13:46

DannyV

194 bronze badges

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

Collectives™ on Stack Overflow

Format number in array within an array_sum

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related