Calculate sum of columns value in Ruby on Rails

Question

I want to calculate the sum of the values in a column. For example:

@items = Item.find_all_by_cart_id(cart)

Item has column quantity. I want the sum of the @items quantity.

aromero · Accepted Answer · 2013-05-13 14:05:37Z

1

items_quantity = @items.map(&:quantity).sum

answered May 13, 2013 at 14:05

aromero

25.8k6 gold badges60 silver badges79 bronze badges

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

Comments

Raghuveer · Accepted Answer · 2013-05-13 14:09:44Z

1

Try this

@items = Item.find_all_by_cart_id(cart).sum(:quantity)

answered May 13, 2013 at 14:09

Raghuveer

2,6273 gold badges31 silver badges61 bronze badges

This is a a cleaner, model related way to do this.