This content has been marked as final.
Show 4 replies
-
1. Re: A really simple calculation field doesn't work
Michael YeNov 13, 2018 2:19 PM (in response to Penn Wang)
6 of 6 people found this helpfulPenn,
I think it should be:
SUM([Number of Aircraft Incurring In-flight Delay])/SUM([Number of Records])
Thanks,
Michael Ye
-
2. Re: A really simple calculation field doesn't work
Penn Wang Nov 13, 2018 2:22 PM (in response to Michael Ye)Hi Michael,
I tried that but didn't work.
I sorted it out by creating another calculation field SUM[Number of Records].
Thanks!
-
3. Re: A really simple calculation field doesn't work
Penn Wang Nov 13, 2018 2:24 PM (in response to Penn Wang)I tried your answer again, [Number of Aircraft Incurring In-flight Delay]/SUM([Number of Records]) works. Thank you!
-
4. Re: A really simple calculation field doesn't work
Michael YeNov 13, 2018 2:46 PM (in response to Penn Wang)
4 of 4 people found this helpfulPenn,
I think that Number of Aircraft Incurring In-flight Delay is already an aggregate level calcs. So it cannot be SUM again.
By the way, if you speak Chinese, I recommend you to join the user group:
Chinese Speakers in North America
Thanks,
Michael Ye