Laravel Sum column database Eloquent

Question

Trying to get the sum of a int field in one of my table should be pretty easy, unfortunately it is not as I'm getting different result whether I use Laravel, MySQL or Excel.

Laravel 5.4 gives me 20506:

Table::sum('field_name');

MySQL gives me 1830:

Select sum(field_name) from table;

And the data from the Excel sheet before importing it into the database: Sum gives me 145689

Any idea? I tried to cast to integer before doing the sum but it doesn't work. All the numbers are pretty big but don't contain comma or dot.

Examples of values I have to sum: (contain sometimes empty cells)

What do you get if you do a foreach sum of all rows in laravel? — ak93
– ak93, Commented Nov 2, 2017 at 13:16

ahmad ali · Accepted Answer · 2017-11-09 14:38:34Z

5

$query = YourModel::query();
$query->withCount([
'activity AS yoursum' => function ($query) {
        $query->select(DB::raw("SUM(amount_total) as paidsum"))->where('status', 'paid');
    }
]);

answered Nov 9, 2017 at 14:38

ahmad ali

1,2652 gold badges10 silver badges17 bronze badges

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

2 Comments

Toby Speight Over a year ago

Thank you for this code snippet, which might provide some limited, immediate help. A proper explanation would greatly improve its long-term value by showing why this is a good solution to the problem, and would make it more useful to future readers with other, similar questions. Please edit your answer to add some explanation, including the assumptions you've made.

Gass Over a year ago

I agree with Toby and I can see after many years no explanation has been added. That's why I'm downvoting.

Sagar Arora · Accepted Answer · 2017-03-03 06:43:25Z

5

You can use laravel aggregate function SUM as :

$result = DB::table('table_name')
                ->select(DB::raw('SUM(field_name) as total_field_name'))
                ->get();

For more details you can follow:

https://laravel.com/docs/5.4/queries

Thanks

answered Mar 3, 2017 at 6:43

Sagar Arora

1,7831 gold badge11 silver badges20 bronze badges

1 Comment

Andrew Over a year ago

It unfortunately doesn't change the result.

EddyTheDove · Accepted Answer · 2017-03-03 06:04:22Z

1

Try with

$result = DB::table(tablename)
->selectRaw('sum(column)')
->get();

If it still gives you wrong result, maybe wait for someone to give you a better answer. This is all I could think of.

answered Mar 3, 2017 at 6:04

EddyTheDove

13.2k2 gold badges40 silver badges46 bronze badges

1 Comment

Andrew Over a year ago

This gives me the same result as the SQL query: Select sum(field_name) from table;

Collectives™ on Stack Overflow

Laravel Sum column database Eloquent

3 Answers 3

2 Comments

1 Comment

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related