id summary reporter owner description type status component version severity resolution keywords cc stage has_patch needs_docs needs_tests needs_better_patch easy ui_ux 28940 Annotate SUM aggregation value as field Vasiliy Maryutenkov nobody "Hello How can I do this in Django without .extra() method? SELECT SUM(column_1) AS total, column_1, column_2 FROM table In your documentation you said that I should create the ticket if I use .extra() method, so I'm here Model.objects.extra(select={'total': 'select sum(field) from model'}) And I also need to use this value in annotation, but it is not possible now :( .annotate(q=F('field')/F('total')) How can I do this?" Uncategorized closed Database layer (models, ORM) 1.11 Normal duplicate Unreviewed 0 0 0 0 0 0