How is the Median Function returning a 0 if there are no zeros in my table?

1

My table contains no 0s:
image

Yet simultaneously, Median is returning a 0
image

how is that possible?

2

@Connor_McCormick Can you share the doc?

3

What’s your email address?

4

I’ve made an access request!

5

Hey @Connor_McCormick i’ve tried adding 200 rows but i don’t get 0 as result fo the formula!
Is there any particular other steps i’m missing?

6

Here, found the minimum failure state:

image
image826×484 7.1 KB

Check the doc again to try yourself

7

I think that’s just the definition of median – it returns the average of the middle two for even count of numbers, in this case 1 and -1

8

Ah, you’re totally right. I did not know averaging the final two results (given an even sample size) was in the definition of median. Thanks!