Re: [GENERAL] How to find avg() of sum()?

2010-04-16 Thread Thomas Kellerer
semi-ambivalent wrote on 16.04.2010 19:57: I have some data fields that I have summed, grouped by a date field. The sums are different. How can I then calculate the average value for those sums? Everything I've tried errors out with something along the lines of using agregates where I can't, or f

[GENERAL] How to find avg() of sum()?

2010-04-16 Thread semi-ambivalent
I have some data fields that I have summed, grouped by a date field. The sums are different. How can I then calculate the average value for those sums? Everything I've tried errors out with something along the lines of using agregates where I can't, or for using multiple values where that is not al