[Fixed]-Django cannot multiply non-int of type 'str'

by

0👍

✅

I would use this:

def _total_amount(self):
    req = QuoteRow.objects.filter(quote=self.pk)
    return sum([i.unit_price * i.quantity for i in req])

It takes one more line but it’s clearer to me.

👤Emilio Conte

1👍

Try using extra()

QuoteRow.objects.filter(quote=self.pk).extra(select = {'total': 'SUM(unit_price * quantity)'},)
👤Amr Abdelaziz

Leave a comment