Dear Django users.
I'm trying to do the sums of the product of two columns ('contract_sum' and
'probability', decimal fields), grouping by a third column, 'stage' (a
choice variable).
I'm also reporting the grouped sums of one of the single columns
('contract_sum')
The single column works just fine, but I just can't get it right with the
product columns.
Below is my code so far:
contracts = (Project.objects.values('stage')
.annotate(contract_sum=Sum('contractSum'))
.annotate(expected_own_production_sum=F(
'contractSum')*F('probability'))
)
a) When I run the query with the single column query, the results are right.
b) When I run the query with both selections, not only is the column
product, wrong, but the single column sums also become wrong.
c) When I run the query with only the product columns, the query returns
zero for all groups, which is definitely wrong.
Can I do this right without going to raw sql?
cheers + thanks, Mikkel
--
You received this message because you are subscribed to the Google Groups
"Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to django-users+unsubscr...@googlegroups.com.
To post to this group, send email to django-users@googlegroups.com.
Visit this group at https://groups.google.com/group/django-users.
To view this discussion on the web visit
https://groups.google.com/d/msgid/django-users/4a6af6b6-d76e-43f7-8223-23da3ead38da%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
