Doing maths on fields in a query

[Thorsten]

Hello,

I am wondering if it is possible to do math on fields inside a query
with using the django syntax for example like

SELECT (buyout / quantity) as buyout_per_item

Currently I am using raw queries, because i couldn't find anything
about such cases.

Greetings,

[Daniel Roseman]

You can use the `extra()` model manager method to include extra calculated fields in your queries.

I would say though that if you're just doing simple calculations, you're not really gaining anything by doing them in the database. It's just as easy to create a model method that returns the calculated value, which you can call as necessary.

--

DR.

[Thorsten]

Thank you, it is working, seems I missed that somehow while searching in the documentation.

P.S. It is not that simple, I just prefer to keep the example as simple as possible, it also includes doing min,avg,max calculations over thousands of entries etc.