#Computation error with Median

building reports desktopintelligence
1

Hi All,

I’m trying to calculate the Median for column in BO 11.5.
Columns in the table are:
<Emp. Name>



<v_Rate_Bucket>

I’m trying to calculate the Median for by <Service and <v_Rate_bucket> but I’m getting commutation error.
I’m calculating Median by creating a variable as =Median() ForEach

Thanks in Advance.

shuchi (BOB member since 2007-09-24)

2

Try like this…

=Median() ForEach(, <v_Rate_bucket>)

Hope this helps you…!!

srijaggu :us: (BOB member since 2007-09-07)

3

Hi,

I tried that but still getting the #Computation error.

Thanks,

shuchi (BOB member since 2007-09-24)

4

Hi,

Are you sure to use the right field ?
You said that the fields which are present in your report are :
<Emp. Name>



<v_Rate_Bucket>

But in your formula :

=Median() ForEach

you are using the field Hourly Rate, which is not present in your report !!
That is why you obtain the computation error.
Modify your formulla with or insert the dimension in your report.

I hope this explaination will help you.

Best Regards,
Cédric Paumard

DeskI & WebI Developer
BI Toolkit - Offices in UK and Holland
http://www.bitoolkit.com

[bitk]Cedric (BOB member since 2008-03-10)

5

I recently had this error, it was because I tried to get the median of a dimension. It must be a measure.

You can update your universe or create a variable that is declared as a measure and equals the dimension field you are using.

Florian F (BOB member since 2009-08-21)