IF [Turbulence] >= -1 AND [Turbulence] <= -0.5
SUM(Field1)/SUM(Number of Records)
I actually did that beforehand and it worked, but I'm wondering if it was possible to do it within a single field. Otherwise the number of fields might get out of hand if I had to do more ranges.
If it's not possible though, I'll stick with your solution.
In just one field you can write this way :
SUM(IF [Turbulence] >= -1 AND [Turbulence] <= -0.5 THEN 1 ELSE 0 END)/SUM([Number of Records])
Let me know if it helps.
Worked perfectly. Thanks!