Skip to Content
0
Former Member
Mar 24, 2009 at 12:00 PM

Encountering problems getting the median value for specific rows alone.

367 Views

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?