calculation the median

hi,

I'd like to calculate the Median within a cube in SQL Server 2005.

I have a duration and the number of occurances --> so it was not
difficult to calculate the average but now I got stuck because I'd like
to calculate the median too.

I just found the following formula - Median(Set_Expression [
,Numeric_Expression ] ) but I don't know how to use it.

Thanks for your help!

.

Relevant Pages

  • Re: berechnungen analysis services
    ... Median KT Duration --> Median KT Duration.) ... Versuch war es ein neues Measure anzulegen. ...
    (microsoft.public.de.sqlserver)
  • Re: calculation the median
    ... I added this as a new Measure in the Calculation window of the Cube: ... dependencies is Median KT Duration --> Median KT Duration.) ...
    (microsoft.public.sqlserver.olap)
  • Re: ADO / ASP / MEDIAN COMPUTATION
    ... spectre wrote: ... > I am looking for a way / an example to compute the median and ... By "SQL" do you mean "SQL Server"? ... This email account is my spam trap so I ...
    (microsoft.public.inetserver.asp.db)
  • Re: "mean" quesiton
    ... Are you referring to median? ... SQL Server MVP ... Columnist, SQL Server Professional ... "george collins" wrote in message ...
    (microsoft.public.sqlserver.server)
  • Re: How to calculate Median in a group of Data
    ... SQL Server MVP ... Columnist, SQL Server Professional ... "Reza Alirezaei" wrote in message ... and I want to calculate median for it. ...
    (microsoft.public.sqlserver.programming)