Skip to content

Instantly share code, notes, and snippets.

@tyaslab

tyaslab/django_arithmetic_aggregate

Created March 30, 2015 03:59
Show Gist options
  • Save tyaslab/fec2d988fadcce5427b5 to your computer and use it in GitHub Desktop.
Save tyaslab/fec2d988fadcce5427b5 to your computer and use it in GitHub Desktop.
Download ZIP
Django < 1.8 arithmetic aggregate more than one field
Raw
django_arithmetic_aggregate
MyModel.objects.aggregate(subtotal=Sum('qty', field='qty * price'))
'qty' ==> fill whatever you want
'qty * price' ==> the real aggregate
annotate is applicable too!
PS:
Django 1.8 can do it using F()
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment