rails calculated field based on 2 columns

Question

This is probably simple but instead of this:

current_cart.line_items.sum(:line_item_total)

I prefer to implement it like this:

current_cart.line_items.sum(:line_item_unit_price * :quantity)

What is the best syntax to build a calculated field based on two fields?

shivashankar · Accepted Answer · 2012-11-11 14:15:59Z

1

You can use

current_cart.line_items.sum("line_item_unit_price * quantity")

to stick with your second option.

answered Nov 11, 2012 at 14:15

shivashankar

1,1771 gold badge10 silver badges16 bronze badges

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

Comments

Salil · Accepted Answer · 2012-11-11 11:20:32Z

0

I think following will work

def total_price
  line_item_unit_price * quantity
end

and then

current_cart.line_items.sum(:total_price)

answered Nov 11, 2012 at 11:20

Salil

47.7k22 gold badges127 silver badges161 bronze badges