Consider the following columns:
Call Value
0.49
0.65
1.22
1.29
1.34
1.64
1.8
2.25
3.86
4.32
5.12
Median 1.64
Quartile 1
0.49
0.65
1.22
1.29
1.34
Expected Median 1.22
BO Returns
The first column in the table contains call values. The median of all the call values is 1.64. BO displays this value as is (correctly). In case of obtaining the median for Quartile 1, BO returns a null value instead of 1.22.
Can anyone please tell me what needs to be done in BO to achieve this value 1.22?