This content has been marked as final.
Show 4 replies

1. Re: How to calculate proportion of values in a field that fall within a range
Rahul Singh Sep 19, 2018 9:58 AM (in response to John Salazar)Hi John,
Try this:
Field1:
IF [Turbulence] >= 1 AND [Turbulence] <= 0.5
THEN 1
ELSE 0
END
Field2
SUM(Field1)/SUM(Number of Records)
Regards,
Rahul

2. Re: How to calculate proportion of values in a field that fall within a range
John Salazar Sep 19, 2018 10:52 AM (in response to John Salazar)Hi Rahul,
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.
Thanks,
John

3. Re: How to calculate proportion of values in a field that fall within a range
Rahul Singh Sep 19, 2018 5:25 PM (in response to John Salazar)Hi John,
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.
Regards,
Rahul

4. Re: How to calculate proportion of values in a field that fall within a range
John Salazar Sep 20, 2018 10:46 AM (in response to Rahul Singh)Worked perfectly. Thanks!